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