I know little about DBI and even less about Oracle, but I just came across DBIx::Procedure::Oracle on CPAN which has this description:

DBIx::Procedure::Oracle - Call PL/SQL stored procedures and functions without writing SQL or needing to know about data types or bindings.

That said, it goes on to talk about using positional parameters (:n) and not named parameters. It queries the definition of the stored procedure from the DB itself and then uses that to decide how many and what type the parameters are. So, it would seem to me that the problem you have is how to define a stored procedure in Oracle to accept a large number of values as arguments without needing to name or number them all indivually? That's very much an Oracle question not a Perl one.

Taking a quick look at the pod for DBD::Oracle (*This has a few PL/SQL examples that might be illuminating for you.) and trying to extrapolate from my long unused DB2 knowledge, I seem to recall that the usual way to handle the type of processing that you are talking about is to do a standard INSERT of the data records into seperate table that is either created on the fly or is defined simply for the purpose of receiving the raw data, and then call the stored procedure to process the raw data from that table into the real tables, possibly removing it from the raw storage table as it goes. That way, the large volumes of values are bound to the INSERT statement in the normal way, and then the procedure can be invoked with just the name of the TABLE that it is to process.

As I said at the top, I am on really shaky ground with this stuff, but it really sounds like your problem is one of how to define a stored procedure to accept large numbers of parameters in a convenient way--an Oracle/SQL problem-- rather than perl one.

Examine what is said, not who speaks.
1) When a distinguished but elderly scientist states that something is possible, he is almost certainly right. When he states that something is impossible, he is very probably wrong.
2) The only way of discovering the limits of the possible is to venture a little way past them into the impossible
3) Any sufficiently advanced technology is indistinguishable from magic.
Arthur C. Clarke.

In reply to Re: Passing Arrays from Perl to Stored Procedures by BrowserUk
in thread Passing Arrays from Perl to Stored Procedures by TheYoungMonk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.