Re: Passing one array per field into procedure.
Date: Tue, 22 Feb 2011 17:22:50 -0800 (PST)
On Feb 21, 12:57 pm, seanD <sean.den..._at_gmail.com> wrote:
> 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 !
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