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:
When I use the above notation, Oracle gives an error about the parameter that parameters types dont match.
Any ideas?
Thanks
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:
Code:
system("sqlplus -S $user_det_orcl <<EOF \n "."whenever sqlerror exit failure; \n"."exec p_test('\@array\');\n"."exit;\n"."EOF\n" );
Any ideas?
Thanks