Basic Oracle Concepts and Programming Question:
How To Execute a Stored Program Unit?
Answer:
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!
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!
| Previous Question | Next Question |
| How To Create a Stored Program Unit? | How Many Data Types Are Supported? |