Pass Perl array to Oracle stored procedure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Saii
    Recognized Expert New Member
    • Apr 2007
    • 145

    Pass Perl array to Oracle stored procedure

    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:
    Code:
    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
    Last edited by eWish; Apr 28 '09, 10:11 PM. Reason: Please use code tags to make the code more readable
Working...