Pass Perl array to Oracle stored procedure

Saii

Expert

Join Date: Apr 2007

Posts: 141

#1: Apr 28 '09

How can we pass a perl array to stored procedure in Oracle.
The parameter I am using in Oracle is type of table of varchar(500). I am using the system command in perl to execute the procedure

Sample:

Expand|Select|Wrap|Line Numbers

 system("sqlplus -S $user_det_orcl <<EOF \n "."whenever sqlerror exit failure; \n"."exec  p_test('\@array\');\n"."exit;\n"."EOF\n" );
 

When I use the above notation, Oracle gives an error about the parameter that parameters types dont match.
Any ideas?
Thanks

« previous question | next question »

Similar Perl bytes

help with Perl code to insert a long string (> 32512 chars) via stored procedure (answers)
How to pass an array from .net to oracle stored procedure (answers)
How to pass an array from .net to oracle stored procedure (answers)
How to pass an array from .net to oracle stored procedure (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,223 network members.