Hi all,



My requirement is - I'll be getting comma separated string as parameter
in my procedure and I need to

insert each word (delimited by comma) as a row into a table.



I'm trying to achieve it by using PL/SQL Table function with a PL/SQL
Table type.



Here is my Procedure.



Procedure prc_ins

is

array_roll tname := tname ('ABCD', 'XYZ'); -- tname is the type
created in database.

begin



insert into tmp select * from TABLE( cast ( array_roll as tname ) );

end;



the above procedure is working fine. But I would like to replace the
('ABCD', 'XYZ') values by a parameter

and declaring the type TNAME in the package header without creating it
in Database like below.



Procedure prc_ins (str)

is

array_roll tname := tname str; -- tname is the type created in
database.

begin



insert into tmp select * from TABLE( cast ( array_roll as tname ) );

end;



Please let me know if there is a way to achieve this



Thanks/rgds

Guna




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

Oracle LazyDBA home page