PL/SQL (MOSC)

MOSC Banner

parse sql in package with cursor

edited Oct 2, 2012 10:39PM in PL/SQL (MOSC) 2 commentsAnswered
Hi all,

   Assume that I creates a package and it contains store procedure call cal_val(). Inside call_val(), I declare cursor cur_data and it contains about 2000 records. After that, I open this cursor and loop by records, calculate (about 5 operates) for per record so I can not use FORALL. Example one of these operates:

  update table_a set val = cur_data(i).value;

  And with 2000 records, oracle will hard parse 2000 times with above sql ? And remember that it inside package !

  I use 9.2.0.4

Thanks

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