How to execute sql files with windows path ?
644479Apr 24 2009 — edited Apr 24 2009Hi , 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