You have a colon instead of a semi-colon on line 12..... > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > [EMAIL PROTECTED] > Sent: 24 October 2001 19:31 > To: Multiple recipients of list ORACLE-L > Subject: This is driving me nuts. What am I doing wrong here? > > SQL> declare > 2 w_a number := 0; > 3 w_b number:= 0; > 4 w_c char(10) := null; > 5 w_d number := 0; > 6 cursor v_c_t is > 7 select a,c,b from civ_test; > 8 begin > 9 for v_c_t_row in v_c_t loop > 10 :w_d := w_d + 1; > 11 :w_a := 0; > 12 :w_c := null: > 13 :w_b := 0; > 14 :w_a := select c from civ_test where v_c_t_row.a = wd; > 15 :w_c := 'v-'||v_c_t_row.c; > 16 :w_b := v_c_t_row.b; > 17 insert into v_civ_test values (w_c, w_b, w_a, w_d); > 18 end loop > 19 end; > 20 / > Bind variable "W_B" not declared. > SQL> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
