Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Passing arrays to an oracle stored procedure

by Moron (Curate)
on Aug 09, 2007 at 10:26 UTC ( #631509=note: print w/ replies, xml ) Need Help??

in reply to Passing arrays to an oracle stored procedure

No you can't bind an array because ORACLE doesn't have arrays. So you just bind some variables and fetch each row into those variables and THEN push them into an array. For example you have $column1 and $column2 which you bind to the oracle variables or columns, depending on how the procedure returns them. You DBI->execute the stored procedure then repeatedly DBI->fetchrow which loads the bound variables from the next row of the resultset and if it succeeded you 'manually' push $column1 into @column1 and $column2 into @column2 before looping back for the next row of the result set.


^M Free your mind!

Comment on Re: Passing arrays to an oracle stored procedure

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://631509]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2015-11-26 05:56 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (696 votes), past polls