Skip to Main Content

DevOps, CI/CD and Automation

1 error has occurred

Your session has timed out.

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

Added on Sep 19 2019

#oracle-call-interface-oci

11 comments

28,160 views