Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Error SP2-0310 ; explain to me why it was fixed by substituting ; with  / (below) the line

Posted on 2007-12-06
4
Medium Priority
?
864 Views
Last Modified: 2013-12-18
I was executing

-- install.sql includes
start c:\TABLES\deletetables.sql;
commit;
start c:\TABLES\createtables.sql;
commit;

So i rung install
sql>start c:\install.sql

it was giving me an  SP2-0310: unable to open file "c:\TABLES\deletetables.sql;"

Then what i did is changing the install.sql to

-- install.sql includes
start c:\TABLES\deletetables.sql
/
commit;
start c:\TABLES\createtables.sql
/
commit;


and it worked fine.

Can you please tell me why is that happening ?
0
Comment
Question by:cscg1976
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 600 total points
ID: 20418137
because START is not a PL/SQL statement, but a SQL/PLUS command, and does hence not require the ;
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20418152
The forward slash / is a statement delimiter. it separates your start command from the commit
0
 
LVL 13

Assisted Solution

by:sonicefu
sonicefu earned 600 total points
ID: 20418172

-- now this is your install.sql 
@@c:\TABLES\deletetables.sql
 
commit;
 
@@start c:\TABLES\createtables.sql
 
commit;

Open in new window

0
 
LVL 12

Assisted Solution

by:jwahl
jwahl earned 300 total points
ID: 20418731
i try to explain what your code did:

start c:\TABLES\deletetables.sql -- starts deletetables.sql successfully
/ -- re-runs previous command (deletetables.sql)
commit;
start c:\TABLES\createtables.sql -- starts createtables.sql successfully
/ -- re-runs previous command (createtables.sql)
commit;
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question