ORA-01036: illegal variable name/number [message #38283] |
Sun, 07 April 2002 19:07 |
Vinuraj
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Hi,
I am trying to create flat files using data from oracle database(version -Oracle8i Enterprise Edition Release 8.1.7.2.0). Most of the time programs runs file, but sometimes I am getting
ORA-01036: illegal variable name/number.
I am working on SunOS 5.8 and using 2 database sessions in the same program. I tried all the solutions given in some earlier messages i found, still getting the error. Please let me know if anybody have more informations regarding this.
Vinu
|
|
|
Re: ORA-01036: illegal variable name/number [message #38287 is a reply to message #38283] |
Mon, 08 April 2002 06:48 |
oraboy
Messages: 97 Registered: October 2001
|
Member |
|
|
I assume you are using UTL_FILE to accomplish yr task.
Check whether ur program does any IMPLICIT conversion by itself..and if any , use explicit TO_CHAR() ,TO_NUMBER() functions so that even unexpected data formats wud be handled by the program
I wish to see ur code before commenting more.
Thanks
Oraboy
|
|
|
Re: ORA-01036: illegal variable name/number [message #38331 is a reply to message #38287] |
Wed, 10 April 2002 22:20 |
Pakshi Rajan
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Hi,
Ora 1036 usally comes when one of the bind variables used in the sql is not found in the OS.
There may be two reasons.
1. You might have made some spelling mistake in the variable name [[not column name]]
2. OS might have faced some memory leak which causes this variable to disapear.
For the reason No. 2 you can overcome by giving entirly different variable name [[YES it works!!!!]] in all the places where u have used using & or && in the sql or : variables if in a pre compiled program.
|
|
|