Home » SQL & PL/SQL » SQL & PL/SQL » SQL* unable to open file
SQL* unable to open file [message #21131] Mon, 15 July 2002 09:24 Go to next message
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 Go to previous message
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.
Previous Topic: Showing a company hierachy with SQL
Next Topic: Re: Very urgent ... Help...!!!
Goto Forum:
  


Current Time: Thu Apr 25 12:54:26 CDT 2024