StoredProc_Package1.htm

CREATE TABLE "SCOTT"."TPACK1"
( "T1" NUMBER
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "USERS" ;

Create Package and a stored procedure referencing the table  "TPACK1"

-- create_pkg1.sql
-- create a packaged procedure which references the table.
CREATE OR REPLACE PACKAGE PKGT1 AS
PROCEDURE storedproc_pkg1(p_Val IN NUMBER);
END PKGT1;"SCOTT"."TPACK1"
/

CREATE OR REPLACE PACKAGE BODY PKGT1 AS
PROCEDURE storedproc_pkg1(p_Val IN NUMBER) IS
BEGIN
INSERT INTO TPACK1 VALUES (p_Val);
END storedproc_pkg1;
END PKGT1;
/
-- create a procedure which references PKGT1.
CREATE OR REPLACE PROCEDURE proc_callpkg1(p_Val IN NUMBER) AS
BEGIN
PKGT1.storedproc_pkg1(p_Val * 2);
END proc_callpkg1;
/

Compile the Package:

Save the package script as

 
 
Now, I am going to call the procedure, proc_callpkg1(), using Oracle_SQLQueryTool, as shown below, add some value (as a parameter), and query the table "TPack1" to view data insertion (after multiplying with 2) with a stored procedure .