PL/SQL (MOSC)

MOSC Banner

Passing list of of data to stored procedure

edited Jul 1, 2015 8:31AM in PL/SQL (MOSC) 4 commentsAnswered


Hi, I have been requested to create a stored procedure (to be called by .net) that will receive multiple input records (table of objects).  For each record, I must issue an update command.  The number of records in the list will be in the thousands.  I have coded the following program which I believe will work, but I am wondering if it will be the most efficient way to receive the list of records or if there is any limitations that would prevent me for receiving thousands of records in this way.  Is this the best way to handle this

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center