Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle ORA-01036 - Illegal variable name/number on Dbal 2.10 #3765

Closed
atay opened this issue Dec 2, 2019 · 2 comments
Closed

Oracle ORA-01036 - Illegal variable name/number on Dbal 2.10 #3765

atay opened this issue Dec 2, 2019 · 2 comments

Comments

@atay
Copy link

atay commented Dec 2, 2019

Bug Report

For new Dbal 2.10.0 on my Oracle connector, it fails. It fails on bindParam function call.
It is still working fine with dbal 2.9.*, so I had to downgrade for now.
Not sure if it's related to #3744

Q A
BC Break yes/no
Version 2.10.0

Summary

Executing code:

        $statement = $this->connection->prepare('CALL apw_user.GET_SPRZ_ID(:v_SPRZ_ID)');
        $statement->bindParam('v_SPRZ_ID', $sprzId, PDO::PARAM_INPUT_OUTPUT, 32);

returns an error:

Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number

which was working fine for dbal 2.9.*.

Current behaviour

Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number

How to reproduce

The procedure in Oracle.

create PROCEDURE GET_SPRZ_ID (NUMER OUT INTEGER) 
AS BEGIN 
  SELECT ID_SPRZ.nextval into NUMER from dual; 
END;
/

Expected behaviour

There should be no error on execution.

@morozov
Copy link
Member

morozov commented Dec 2, 2019

It must be a duplicate of #3722.

@github-actions
Copy link

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jul 30, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants