Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Execute a Stored Program Unit?

If you want to execute a stored program unit, you can use the EXECUTE statement. The example script below shows how to executes a stored program unit:

SQL> set serveroutput on;

SQL> CREATE PROCEDURE Hello AS

2 BEGIN

3 DBMS_OUTPUT.PUT_LINE('Hello world!');

4 END;

5 /

Procedure created.

SQL> EXECUTE Hello;

Hello world!

 163 views

More Questions for you: