Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to execute sql files with windows path ?

644479Apr 24 2009 — edited Apr 24 2009
Hi , here's my stupid question :

I have my parent SQL script say A.sql in directory C:\program files\my files\A.sql
A.sql has calls to multiple sql files like this
@@1.sql;
@@2.sql;

When I call A.sql using sqlplus as:
sqlplus <username> <connection_string> @"C:\program files\my files\A.sql"
A.sql gets executed but then while calling "1.sql" it fails with the error
SP2-0310: unable to open file "C:\program.sql"

This is happening because of the space, how can this be handled. thx in advance :)

Regards,
Neuron
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2009
Added on Apr 24 2009
11 comments
7,761 views