Re: Re: Passing Arrays from Perl to Stored Procedures

Thanks for the code posted!...but how is it relevant to the problem at hand ?

What is required is the same kind of Stored Procedure parameter passing to be done, but when the parameter is an array of values.

All new ideas welcome...

Comment on Re: Re: Passing Arrays from Perl to Stored Procedures

Replies are listed 'Best First'.
Re: Re: Re: Passing Arrays from Perl to Stored Procedures by Anonymous Monk on Mar 08, 2003 at 09:18 UTC
Ok your probally doing something like this: `open (CSVFILE, input.csv); while (!eof(CSVFILE)) { $currLine = <CSVFILE>; split /\,/, $currLine, @curline; dbi_sub (@currline); }` [download] where dbi_sub will feed that to your stored proc. Now as said before I would just have oracle do this make a PL/SQL function that takes a single varchar(255) as a parameter, being the name of the textfile and read it in. But another method would be to pass the $currLine that contains a string of parameters seperated by commas and have your stored procedure parse it. But you never answered the $25,000 question, why aren't you having oracle do this for you. It can and more effecietly than perl probally, but then again the great stored procedures debate is something for the grand council of DB admin and RDMS coder wizards to debate.	[reply] [d/l]

Replies are listed 'Best First'.

open (CSVFILE, input.csv);
while (!eof(CSVFILE)) {
   $currLine = <CSVFILE>;
   split /\,/, $currLine, @curline;
   dbi_sub (@currline);
}
[download]