Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 866
  • Last Modified:

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 ?
0
cscg1976
Asked:
cscg1976
3 Solutions
 
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
 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now