Re: ERROR IS: ORA-01007: variable not in select list

From: Sudhir <nshanmugam_at_gmail.com>
Date: Tue, 2 Feb 2010 06:26:00 -0800 (PST)
Message-ID: <79eec258-cb22-4366-a57b-59f45e45063c_at_36g2000yqu.googlegroups.com>



On Feb 2, 1:47 am, Shakespeare <what..._at_xs4all.nl> wrote:
> Op 2-2-2010 1:13, Sudhir schreef:
>
>
>
>
>
> > I have a cursor inside a procedure which fetches some records using
> > dynamic query.
> > Now I need to insert these values into a table long with two more
> > values, one is a unique ID and the other is testcase name.
> > Unique ID- It can be anything. In this case I use a variable J and
> > increment it by 1 each time when I fetch the record.
> > Test case name will be a static value that comes as a IN parameter of
> > SP.
>
> > tcnum:='Testcase10';
> > j:=1;
>
> > loop
> > fetch.....
> > exit..notfound
> > insert into tableA
> > (snum,firstname,lastname,status,add1,add2,addcity,addstate,addzip,tcnum,ord­er_ID)
> > values (
>
> > o_sban.sNUM ,
> > o_sban.FIRSTNAME ,
> > o_sban.LASTNAME ,
> > o_sban.STATUS ,
> > o_sban.sADDRADDR1 ,
> > o_sban.sADDRADDR2 ,
> > o_sban.sADDRCITY ,
> > o_sban.sADDRSTATE ,
> > o_sban.sADDRZIP ,
> > tcnum ,
> > j
> > ) ;
>
> > j:=j+1;
>
> > end loop;
>
> > The script used to work without any issue when the column in select
> > statement was equal to column in the table.
> > Since I need those two values, I added it in the table and modified
> > the script accordingly. The datatype are same in both select statement
> > and table.
> > When I ran the script I started getting "ERROR IS: ORA-01007: variable
> > not in select list".
> > Can anyone help me on this?
> > I appreciate your help...
>
> Try renaming your variable tcnum. Looks like it's the same as the column
> name; your insert statement may interpret it wrong in the values clause,
> and assume you mean the column value.
> So:
>
> l_tcnum:='Testcase10';
> ....
> o_sban.sADDRSTATE ,
> o_sban.sADDRZIP ,
> l_tcnum ,
> j
>
> Shakespeare- Hide quoted text -
>
> - Show quoted text -

I tried renaming to I_tcnum, but still I'm getting the same error "ERROR IS: ORA-01007: variable
not in select list". Received on Tue Feb 02 2010 - 08:26:00 CST

Original text of this message