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.
Does anyone know if I can define this:
--
TYPE t_task_cmd_list IS TABLE OF VARCHAR2(1000)
INDEX BY BINARY_INTEGER;
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.
Any pointers to examples would be helpful, I just can't even find the
subject discussed anywhere :-(
Richard.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
