Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help in Bind Variable

ORA-00007Mar 30 2015 — edited Mar 30 2015

Hi ,

Can you share solution for the below logic

DECLARE

A NUMBER ;

BEGIN

FOR I IN 1..10 LOOP

A := &ENTER_THE_VALUE_FOR_A ;

DBMS_OUTPUT.PUT_LINE ( A);

END LOOP;

END;

My requirement is to get the value 10 times via bing variable , whereas in the above code If I enter the first time for the rest of the loop it is taking the same , can you please help me to correct the code .

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2015
Added on Mar 30 2015
2 comments
509 views