Hello, I have two questions, one which I think is probably simple.
1. (the simple one). Is there a list of all the ora_type codes somewhere (e.g. ORA_CLOB, 24) 2. How do I pass an array from perl to a PL/SQL stored procedure using DBI? I have the following types in my database: SQL> desc id_rec Name Null? Type ----------------------------------------- -------- ------------------------ ---- ID NUMBER SQL> desc id_tab id_tab TABLE OF ID_REC Name Null? Type ----------------------------------------- -------- ------------------------ ---- ID NUMBER Basically, this allows me to set up an object which is an array of numbers. I have a stored procedure which can accept this as the input parameter: SQL> desc stuff PROCEDURE stuff Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- P_STUFF_LIST ID_TAB IN I know how to execute this procedure in java/JDBC and SQL*Plus. Is it possible using DBI? Thanks, Sue
