Home » RDBMS Server » Server Administration » ORA 1036 illegal variable name/number
ORA 1036 illegal variable name/number [message #58892] Fri, 10 October 2003 08:08 Go to next message
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
Member
Hi,
When modifying one existing pro*c program,
i am getting the following error.
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.

I read few articles on the net but somehow i could not fix the bug.
I would be grateful if someone can provide me more details on what might
cause this error.
I suspect i get this error in a function which has some
sql statements which run for more than 10 to 15 times till the required
data is found.
Thanks in advance.
Giridhar
Re: ORA 1036 illegal variable name/number [message #58977 is a reply to message #58892] Mon, 20 October 2003 05:52 Go to previous message
Maninder
Messages: 2
Registered: October 2003
Junior Member
As far as I know this is a bug in Pro*C version 8.1.6. Are you using this version?
The solution is to use Pro*C version 8.1.5 with database version 8.1.6.

Regards - maninder
Previous Topic: How to apply patch on Oracle software
Next Topic: what is missing?
Goto Forum:
  


Current Time: Fri Sep 20 15:28:53 CDT 2024