Can't execute with @filename - URGENT! [message #76] |
Thu, 10 January 2002 17:59 |
winter
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
I’ve been creating sql files and storing it in C:OracleOra81bin. I can execute all my files by typing the command @filename all the while.
But recently I tried to execute the file in the same path, it returned error message: SP2-0310: unable to open file "filename.sql". I tried to execute the files that were executed successfully before and the same error message displayed.
I’ve also tried to type the full path: @C:OracleOra81binfilename and I got the same error message: SP2-0310: unable to open file “C:OracleOra81binfilename.sql”.
Can anyone of you tell me what has gone wrong? I do need help urgently and thanks in advanced for the advices.
|
|
|
Re: Can't execute with @filename - URGENT! [message #208 is a reply to message #76] |
Mon, 28 January 2002 18:43 |
Diwakar Bhandari
Messages: 7 Registered: January 2002
|
Junior Member |
|
|
Well the only reason that I see for this is that somehow ur oracle classpath has changed accidentally ....
Go to system..environment ...classpath and check for C:OracleOra81bin ; if its not there , then add it ..
Hope this helps
Diwakar
|
|
|
|