Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table type as input to stored proc

Matthew_LeeJan 31 2012 — edited Feb 1 2012
I have a package,body and the proc uses table type as input
say

create or replace
PACKAGE test_pkg AS

TYPE type_tab IS TABLE OF table1.column1%TYPE INDEX BY PLS_INTEGER;

PROCEDURE test_proc
(
pid IN type_tab,

);

END test_pkg;


The test_proc has some code in it, and all the package, body is compiled.
Now how do I execute the proc ? how do I pass table type as input just to execute it in toad or sqldeveloper ?

thanks
Lee
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 29 2012
Added on Jan 31 2012
8 comments
9,103 views