Keep It Simple, Stupid | |
PerlMonks |
Re: Passing Arrays from Perl to Stored Proceduresby OM_Zen (Scribe) |
on Mar 07, 2003 at 18:05 UTC ( [id://241212]=note: print w/replies, xml ) | Need Help?? |
Hi , The backend stored procedure , HOW can a stored procedure accept an array first .You are thinking of passing an array to stored procedure , but how iwll a stored procedure accept it The procedure written like
Hence trying to pass an array to a stored procedure which can never accept an array is not how it could be working That you could do is concatenate the scalar values into a single scalar value in perl and then send it to the Orcale stored procedure and then parse it with substr inside the oracle procedur and use it like
The stored procedure has to
The idea of sending arrays to stored procedures is not that good in that stored procedures , I mean the databases do not have these array only the table and record type , mya be try using those
In Section
Seekers of Perl Wisdom
|
|