Execute a Simple Stored Procedure in Oracle

Q

How To Execute a Stored Program Unit in Oracle?

✍: FYIcenter.com

A

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!

 

Introduction to Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-16, 137👍, 0💬