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

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 ?
cscg1976Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
because START is not a PL/SQL statement, but a SQL/PLUS command, and does hence not require the ;
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
imitchieCommented:
The forward slash / is a statement delimiter. it separates your start command from the commit
0
 
sonicefuCommented:

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

Open in new window

0
 
jwahlCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.