Home » SQL & PL/SQL » SQL & PL/SQL » Can't execute with @filename - URGENT!
Can't execute with @filename - URGENT! [message #76] Thu, 10 January 2002 17:59 Go to next message
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 Go to previous messageGo to next message
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
Re: Can't execute with @filename - URGENT! [message #1161 is a reply to message #76] Sun, 07 April 2002 07:06 Go to previous message
mojo
Messages: 2
Registered: April 2002
Junior Member
i have done this b4, make sure you end the file name with the ".sql" suffix
Previous Topic: Difference between Varchar dates
Next Topic: bulk loading
Goto Forum:
  


Current Time: Tue Apr 16 17:40:52 CDT 2024