Re: Passing one array per field into procedure.

From: onedbguru <>
Date: Tue, 22 Feb 2011 17:22:50 -0800 (PST)
Message-ID: <>

On Feb 21, 12:57 pm, seanD <> 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? Received on Tue Feb 22 2011 - 19:22:50 CST

Original text of this message