Home » Developer & Programmer » Precompilers, OCI & OCCI » ORA 1036 illegal variable name/number
ORA 1036 illegal variable name/number [message #94026] Fri, 10 October 2003 23:05 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
icon14.gif  Re: ORA 1036 illegal variable name/number [message #137254 is a reply to message #94026] Wed, 14 September 2005 02:50 Go to previous message
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
Junior Member

Hi...,

Check whether the bind variable is defined locally in that called function... if it is global then it will through the error like "1036"....

Hope this will solve ur problem.....

Regards,
Shamsh Pervaiz
Previous Topic: How can i manipulate object with ansi dynamic sql 4?
Next Topic: How to fetch the length of RAW field
Goto Forum:
  


Current Time: Tue Oct 27 13:44:31 CDT 2020