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 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 . |
|