SqlPlus not terminating sql script

Question

I have a file with the folowing script:

BEGIN
    ...
    a bunch of inserts
    ...
    COMMIT;

EXCEPTION
    WHEN OTHERS THEN ROLLBACK;
END;

When I execute this in sqlplus I get the following:

SQL> @file.sql
382

It's as if he's not ending the block. I'm new to using pl/sql and sqlplus, so I don't know if I'm doing something wrong.

Any ideas?

Tony Andrews · Accepted Answer · 2010-02-17 15:12:48Z

13

You need to add one more line after the final END; like this:

Just a slash as the first character on the line, and then a new line.

answered Feb 17, 2010 at 15:12

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Megacan Over a year ago

Looks like I posted my reply at the same time. Thanks for the answer.

Megacan · Accepted Answer · 2010-02-17 16:29:30Z

0

Ok, I figured it out. I should have search better in the documentation before posting the question here.

Anyway according to this link: http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch4.htm#sthref840

SQL*Plus treats PL/SQL subprograms in the same manner as SQL commands, except that a semicolon (;) or a blank line does not terminate and execute a block. Terminate PL/SQL subprograms by entering a period (.) by itself on a new line. You can also terminate and execute a PL/SQL subprogram by entering a slash (/) by itself on a new line.

Instead of END you must finish with /.

edited Feb 17, 2010 at 16:29

answered Feb 17, 2010 at 15:14

Megacan

2,5183 gold badges20 silver badges31 bronze badges

Collectives™ on Stack Overflow

SqlPlus not terminating sql script

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related