Re: Passing one array per field into procedure.
From: onedbguru <onedbguru_at_yahoo.com>
Date: Tue, 22 Feb 2011 17:22:50 -0800 (PST)
Message-ID: <2a29db70-02e5-480b-a627-f70c148f5309_at_by6g2000vbb.googlegroups.com>
On Feb 21, 12:57 pm, seanD <sean.den..._at_gmail.com> wrote:
> All,
>
> I hope this is not too vague of a question, but let me know if better
> clarification is needed. I am going to be replacing a java/hibernate
> based "data feed" with a pl/sql package. By data feed, I mean Oracle
> fusion will be used to call our stored procedures with data to be
> integrated into our schema. By integrated, I mean - foreign keys
> looked up and populated, data validations, etc. It had been strongly
> suggested that I use arrays as the arguments to the stored procedure
> instead of "table of" .
>
> My questions are: Anyone have experience calling a stored procedure
> with one array per field where there are a large number of fields
> (like 30+)? I ask because there are not really 3 dimensional arrays
> to be used righ? Does anyone have any thoughts on this approach?
> Again, this will be called from java. the database is 10G. Any
> ideas (links) on how to manage these arays once they are passed in?
>
> Any ideas are welcomed. And again if I have been unclear please let
> me know.
>
> Thanks !
>
> Steve
Date: Tue, 22 Feb 2011 17:22:50 -0800 (PST)
Message-ID: <2a29db70-02e5-480b-a627-f70c148f5309_at_by6g2000vbb.googlegroups.com>
On Feb 21, 12:57 pm, seanD <sean.den..._at_gmail.com> wrote:
> All,
>
> I hope this is not too vague of a question, but let me know if better
> clarification is needed. I am going to be replacing a java/hibernate
> based "data feed" with a pl/sql package. By data feed, I mean Oracle
> fusion will be used to call our stored procedures with data to be
> integrated into our schema. By integrated, I mean - foreign keys
> looked up and populated, data validations, etc. It had been strongly
> suggested that I use arrays as the arguments to the stored procedure
> instead of "table of" .
>
> My questions are: Anyone have experience calling a stored procedure
> with one array per field where there are a large number of fields
> (like 30+)? I ask because there are not really 3 dimensional arrays
> to be used righ? Does anyone have any thoughts on this approach?
> Again, this will be called from java. the database is 10G. Any
> ideas (links) on how to manage these arays once they are passed in?
>
> Any ideas are welcomed. And again if I have been unclear please let
> me know.
>
> Thanks !
>
> Steve
Can you provide a psuedo-code example?
would you be referring to PL/SQL Collections and Records? http://download.oracle.com/docs/cd/E11882_01/appdev.112/e17126/composites.htm http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm Received on Tue Feb 22 2011 - 19:22:50 CST