ORACLE - How do I run a begin/end command in sqlplus command line

Question

I'm following an APEX tutorial for beginners, but it does not explains a lot of things, so I have no clue about what I'm doing wrong.

I need to run this command on a sysdba command line :

BEGIN
APEX_INSTANCE_ADMIN.REMOVE_WORKSPACE(DEV_WORKSPACE, y, y)
END;

But it refuses to run. Each time I press the enter key, it creates a new numerated line.

How do I finish entering the command? It will run automatically, or I need to call it?

Thank you gile, aleksej and Poole. Oracle guides are chaotic. They assume that the reader knows everything else. — xihocipi
– xihocipi, Commented Apr 26, 2017 at 15:19

xihocipi · Accepted Answer · 2017-04-26 16:01:34Z

1

Add a slash at the end of the command.

BEGIN
APEX_INSTANCE_ADMIN.REMOVE_WORKSPACE('DEV_WORKSPACE', 'y', 'y');
END;
/

xihocipi

451 silver badge4 bronze badges

answered Apr 26, 2017 at 14:53

gile

6,0341 gold badge30 silver badges33 bronze badges

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

5 Comments

@xihocipi - the statement inside the block needs a semicolon at the end as well.

¿should finish the second line with ";" ??

Yes. @Alex Poole corrected the statement in the answer (thanks).

Oh, I see. It is like c. Each line ends with a semicolon.

@xihocipi - the y values should be in single quotes too, to make them string literals - ...(DEV_WORKSPACE, 'Y', 'Y');. The docs are here.