Table type as input to stored proc
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