By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

Pass Perl array to Oracle stored procedure

Saii
Expert 100+
P: 145
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
  1. 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
Apr 28 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.