PL/SQL (MOSC)

MOSC Banner

How can add loop value (dynamic) in variable

edited Sep 7, 2018 12:47AM in PL/SQL (MOSC) 5 commentsAnswered

Dear all,

Kindly let me know how can we add loop value in our variable as shown below?

"i" is loop value while changed_attributes is the variable.

when i write it like below it throws error.

FOR i in 1..p_loop_cnt
loop
   dbms_output.put_line('how data appears '|| changed_attributes(i).shipped_quantity);

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