Do you need a space when declaring the variable, w_b number := 0? -----Original Message----- [EMAIL PROTECTED] Sent: Wednesday, October 24, 2001 2:31 PM To: Multiple recipients of list ORACLE-L
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: eric harrington 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).
