How To Create a Stored Program Unit

Q

How To Create a Stored Program Unit? - Oracle DBA FAQ - Introduction to PL/SQL

✍: FYIcenter.com

A

If you want to create a stored program unit, you can use the CREATE PROCEDURE or FUNTION statement. The example script below creates 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.

2007-04-25, 4571👍, 0💬