Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

fails with an ORA-01036: illegal variable name/number on 18c PRO*C

Noel McCuskerSep 19 2019 — edited Sep 24 2019

Hi,

We recently upgraded to Oracle 18c. We are getting problems running pro*c code now that used to work fine at 12c.

The errors seem to be around the use of indicator variables.

We are getting the error:

ORA-01036: illegal variable name/number

Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 - Production Version 18.7.0.0.0

Solaris 11.3 SPARC

Thanks for any help

This post has been answered by mcessna on Apr 8 2022
Jump to Answer

Comments

Jan
Not experienced with the windows implementation, only on linux ... but maybe it may help ...
cx_Oracle is only the bridge between python and the oci interfaces of Oracle, an exposure of the c-api's towards python.
On linux you must set the LD_LIBRARY_PATH variable to the location where the oracle client libraries can be found. (typically something linke libclntsh.so.*). So ... I guess that on a windows environment the client dll's should be in the path (%PATH%) ... Hope somebody can confirm or correct this. Maybe it may help ...
1 - 1

Post Details

Added on Sep 19 2019
11 comments
29,408 views