OraFAQ Forum: SQL & PL/SQL » ORA-01007: variable not in select list

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01007: variable not in select list

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01007: variable not in select list [message #15311]

Thu, 30 September 2004 07:23

Zoe
Messages: 9
Registered: October 2003

Junior Member

I am getting this error message:

ORA-01007: variable not in select list.

I understand what it means and I have read a few articles on it, but I don't know how to get around it. It is very confusing... This is a PL/SQL page reading values from an Oracle database and putting them in a table, it is a simple 'select * from' query, it worked fine about a week ago and has suddenly stopped working!!

Can anyone enlighten me? Or tell me how to get it working again??

Cheers
Zoe

Report message to a moderator

Re: ORA-01007: variable not in select list [message #15314 is a reply to message #15311]

Thu, 30 September 2004 08:46

Larry Lufkin
Messages: 44
Registered: March 2004

Member

You must be selecting or fetching INTO something (usually a record type). Your INTO target, whatever it is, doesn't match column for column your SELECT list. Either you changed the table you're fetching from or you changed the INTO target.

Report message to a moderator

Re: ORA-01007: variable not in select list [message #16332 is a reply to message #15314]

Tue, 23 November 2004 10:11

Jeff L. Hansen
Messages: 1
Registered: November 2004

Junior Member

I initially looked in the error messages manual, but did not find the error listing.

Your posting here was very straight forward and immediately illuminated my issue, which was readily corrected!

Thanks for your efforts in the Oracle world.

Jeff

Report message to a moderator

Re: ORA-01007: variable not in select list [message #145556 is a reply to message #15314]

Thu, 03 November 2005 15:37

aschreiber
Messages: 1
Registered: November 2005

Junior Member

Bingo! This solution worked for me too. I was having the same problem.

Thanks!

Report message to a moderator

Re: ORA-01007: variable not in select list [message #226910 is a reply to message #15311]

Mon, 26 March 2007 22:10

lovenelza
Messages: 8
Registered: March 2007

Junior Member

Hello. I'd like to ask some help. I'm getting this error too but the weird thing is that it only occurs in the branches (I'm at the data center, our IT office).

Our user is posting the changes in the policy but they wasn't able to post the changes.

I tried to duplicate the error using the same username/password, same data and program but it can't be done. I was able to post the record.

We already checked the SELECT statement and INTO statement. It shows the same number of variables. What can you say about this? Does the location/connection has something to do with it?

Report message to a moderator

Re: ORA-01007: variable not in select list [message #226947 is a reply to message #226910]

Tue, 27 March 2007 00:23

Frank
Messages: 7901
Registered: March 2000

Senior Member

Does your user work from a distributed database?
Does (s)he have a local version of your application (if No, did you check? Maybe, if it's a client-server app (s)he decided things would run smoother when running things locally)

Report message to a moderator

Re: ORA-01007: variable not in select list [message #227023 is a reply to message #226947]

Tue, 27 March 2007 02:51

lovenelza
Messages: 8
Registered: March 2007

Junior Member

We are running in a centralized database. All branches are connected to the data center.

They don't have it in the local machine because all application are dump in the branch server. They connect to the server to access the application

Report message to a moderator

Previous Topic:	Help with String (Instr)
Next Topic:	Help with truncating minutes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 05:07:21 CDT 2025