[Oracle] PL/SQL Quick Start

Create Package

CREATE OR REPLACE 
PACKAGE PKG_TEST AS 
   /* TODO enter package declarations 
     (types, exceptions, methods etc) here */ 
END PKG_TEST;

Create Package Body

Update Package

Execute Stored Procedure

var o_message varchar2;
var o_return_code number;
exec package1.test_hello('Albert',:o_message, :o_return_code);
print o_message;
print o_return_code;