Hi, > I am using Perl DBI/DBD for Oracle. I have a lot of PL/SQL, and I can't > find any mention of whether or not Perl DBI can receive Oracle PL/SQL > structures (PL/SQL tables of type RECORD) back from a call to a PL/SQL > call. > > TYPE t_task_cmd_list IS TABLE OF VARCHAR2(1000) > > FUNCTION get_new_tasks RETURN t_task_cmd_list; > >.. and then read back the strings from the PL/SQL structure into an > array in Perl? > > > > This PL/SQL function builds the t_task_cmd_list string-array internally > by reading a whole bunch of database stored meta data. So the 'array' > can't be build with a simple 'select ....' in the Perl itself.
but this should work: select * from table (cast ( get_new_tasks as t_task_cmd_list )) Regards, Martin
