SQL* unable to open file [message #21131] |
Mon, 15 July 2002 09:24 |
Kristi
Messages: 4 Registered: June 2002
|
Junior Member |
|
|
Hello,
Using Windows Task Scheduler, I have scheduled SQL* to open up and run a SQL file.
The syntax I used is @C:CLAIM_NO.SQL. SQL* says unable to open file.
The file is at that location, what is the problem?
Thanks in advance for your help!
|
|
|
Re: SQL* unable to open file [message #21132 is a reply to message #21131] |
Mon, 15 July 2002 10:39 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Just use
@C:CLAIM_NO
becuase the tool may be adding .sql to the file.
since it is already claim_no.sql, the tool now looks for C:CLAIM_NO.SQL.SQL which never exists.
|
|
|