Home -> Usenet -> comp.databases.oracle -> Help, Pls--How do I use dynamic varaibles within a loop?

Help, Pls--How do I use dynamic varaibles within a loop?

From: Les <exlibris_at_sprynet.com>
Date: Thu, 24 Jun 1999 22:29:31 -0700
Message-ID: <377313BB.87BDD1EF_at_sprynet.com> 






I am trying to input three records into a table
using a loop, but it does not work the way I
envisioned it. I get no chance to input 2nd and
third name. Any suggestions?




SQL>   declare


  2    max_rec  int := 3;


  3    i            int := 1;


  4    BEGIN


  5          for i in 1..max_rec loop
  6          insert into cust
  7          (cno, name)
  8           values
  9          (&no, '&namee');
 10          end loop;
 11     end;




 12  /


Enter value for no: 10


Enter value for namee: Bubba

old   9:         (&no, '&namee');
new   9:         (10, 'Bubba');





PL/SQL procedure successfully completed.



SQL> select * from cust;



      CNO NAME



--------- ----------

        1 Alan
        2 Bill
        3 Charles
       10 Bubba
       10 Bubba
       10 Bubba





6 rows selected.



SQL>


As you see, the loop executed three times, inserting
identical record. Now what?
Received on Fri Jun 25 1999 - 07:29:31 CEST












Original text of this message