OraFAQ Forum: Forms » ORA-01036: illegal variable name/number

Home » Developer & Programmer » Forms » ORA-01036: illegal variable name/number (oracle 10g Forms [32 Bit] Version 10.1.2.0.2 (Production), window Xp)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-01036: illegal variable name/number [message #555929]

Wed, 30 May 2012 00:50

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 230 times)

Report message to a moderator

Re: ORA-01036: illegal variable name/number [message #555941 is a reply to message #555929]

Wed, 30 May 2012 01:24

Littlefoot
Messages: 16967
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?

Report message to a moderator

Re: ORA-01036: illegal variable name/number [message #555965 is a reply to message #555941]

Wed, 30 May 2012 04:53

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.

Report message to a moderator

Re: ORA-01036: illegal variable name/number [message #555980 is a reply to message #555965]

Wed, 30 May 2012 06:49

cookiemonster
Messages: 9148
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 22:19:01 CDT 2013

Total time taken to generate the page: 0.09325 seconds