Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2014-10-02 11:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (55 votes), past polls