Home » Developer & Programmer » Forms » ORA-01036: illegal variable name/number (oracle 10g Forms [32 Bit] Version 10.1.2.0.2 (Production), window Xp)
ORA-01036: illegal variable name/number [message #555929] Wed, 30 May 2012 00:50 Go to next message
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
Senior Member
I have developed a form which is running fine most of the time,

but some time it gives error

unable to insert record and if we see detail it shows

ORA-01036: illegal variable name/number

error.jpg is attached.
if there is some problem, it should not pass any entry and if there is no problem then why it gives error of illegal variable?

Regards
  • Attachment: Error.JPG
    (Size: 298.82KB, Downloaded 363 times)
Re: ORA-01036: illegal variable name/number [message #555941 is a reply to message #555929] Wed, 30 May 2012 01:24 Go to previous messageGo to next message
Littlefoot
Messages: 18821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
Quote:

ORA-01036: 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 you try to run the form in debug mode and try to detect the culprit?
Re: ORA-01036: illegal variable name/number [message #555965 is a reply to message #555941] Wed, 30 May 2012 04:53 Go to previous messageGo to next message
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
Senior Member
Sir thanks for prompt reply.

but this error occurs only sometime. rest of the time it works fine and smooth.

my question is ...> if some variable is not being bound, then it should display error all the time. where as it displays error sometime and sometime it works fine.
Re: ORA-01036: illegal variable name/number [message #555980 is a reply to message #555965] Wed, 30 May 2012 06:49 Go to previous message
cookiemonster
Messages: 10570
Registered: September 2008
Location: Rainy Manchester
Senior Member
In the screenshot the values list appears to have gone missing.
I suggest you raise this with oracle support.
Previous Topic: Import CSV directly into FORM 6 and d2kwutil and reading from file (win_api_file.read_file)(merged)
Next Topic: Problem with Java Classes, Array in Forms 11g
Goto Forum:
  


Current Time: Wed Apr 16 08:44:28 CDT 2014

Total time taken to generate the page: 0.13809 seconds