Execute Oracle SQL command after PL/SQL block

Question

I've an SQL file which has some PL/SQL scripts and some DML scripts, but I'm not able to run normal DML commands just after a PL/SQL block IN SQL Developer. For e.g.

BEGIN
    -- Some Statements
END;

UPDATE TABLE TABLE_NAME SET FLD_NAME = SOMETHING;

Do I need to change anything here so that I can run these commands.

PS: I don't want to put everything in BEGIN ... END block.

As others have already told you, you need a / after the anonymous PL/SQL block. With that in place, your script works as expected (tested in SQL Developer 4). If you still get an error, you need to edit your question and provide additional information: the contents of your PL/SQL block, the SQL Developer version you're using, how you run your script (run statement / run script / ... ), the exact error message you get etc. — Frank Schmitt
– Frank Schmitt, Commented Jan 20, 2017 at 14:42

ASz · Accepted Answer · 2017-01-20 13:57:14Z

4

try put / after anonymous block:

BEGIN
    -- Some Statements
END;
/

UPDATE TABLE TABLE_NAME SET FLD_NAME = SOMETHING;

answered Jan 20, 2017 at 13:57

ASz

1193 bronze badges

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

Collectives™ on Stack Overflow

Execute Oracle SQL command after PL/SQL block

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related