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?

Have a look at [this](http://stackoverflow.com/questions/1079949/when-do-i-need-to-use-a-semicolon-vs-a-slash-in-oracle-sql), in particular the most voted answer. — Aleksej, Apr 26 '17 at 14:53
[Have a look at this too](http://stackoverflow.com/q/20971731/266304). — Alex Poole, Apr 26 '17 at 15:11
Thank you gile, aleksej and Poole. Oracle guides are chaotic. They assume that the reader knows everything else. — xihocipi, Apr 26 '17 at 15:19

score 1 · Accepted Answer · edited Apr 26 '17 at 16:01

1

Add a slash at the end of the command.

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

edited Apr 26 '17 at 16:01

xihocipi

answered Apr 26 '17 at 14:53

gile

1

@xihocipi - the statement inside the block needs a semicolon at the end as well. – Alex Poole Apr 26 '17 at 15:09
¿should finish the second line with ";" ?? – xihocipi Apr 26 '17 at 15:11
Yes. @Alex Poole corrected the statement in the answer (thanks). – gile Apr 26 '17 at 15:12
Oh, I see. It is like c. Each line ends with a semicolon. – xihocipi Apr 26 '17 at 15:13
1

@xihocipi - the `y` values should be in single quotes too, to make them string literals - `...(DEV_WORKSPACE, 'Y', 'Y');`. [The docs are here](https://docs.oracle.com/database/121/AEAPI/apex_instance.htm#AEAPI252). – Alex Poole Apr 26 '17 at 15:13

1 Answers1