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 220.127.116.11.0 - Production Version 18.104.22.168.0
Solaris 11.3 SPARC
Thanks for any help
The full error text is:
SQL> @oerr ORA-01036
01036, 00000, "illegal variable name/number"
// *Cause: Unable to find bind context on user side
// *Action: Make sure that the variable being bound is in the sql statement.
Did your recompile program using the 18c proc program and the 18c libraries?