in reply to DBI Oracle. how to pass a record as parameter to PL/SQL function

Read http://search.cpan.org/~pythian/DBD-Oracle-1.22/Oracle.pm and in particular http://search.cpan.org/~pythian/DBD-Oracle-1.22/Oracle.pm#Returning_A_Recordset. BTW, $arr_data in your example is not an array.

  • Comment on Re: DBI Oracle. how to pass a record as parameter to PL/SQL function

Replies are listed 'Best First'.
Re^2: DBI Oracle. how to pass a record as parameter to PL/SQL function
by andre_tux (Initiate) on Mar 31, 2009 at 08:47 UTC

    I have already gone through the DBD-Oracle documentation.
    So it would seem that what I want to do it not possible at the moment, due to the fact that we can only pass atomic parameters to a PL/SQL function.

    PS: I see that I have a typo in my example regarding the array. :-)

    Thanks

[reply]

In Section Seekers of Perl Wisdom