Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01007: variable not in select list
ORA-01007: variable not in select list [message #15311] Thu, 30 September 2004 07:23 Go to next message
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
Re: ORA-01007: variable not in select list [message #15314 is a reply to message #15311] Thu, 30 September 2004 08:46 Go to previous messageGo to next message
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.
Re: ORA-01007: variable not in select list [message #16332 is a reply to message #15314] Tue, 23 November 2004 10:11 Go to previous messageGo to next message
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
icon7.gif  Re: ORA-01007: variable not in select list [message #145556 is a reply to message #15314] Thu, 03 November 2005 15:37 Go to previous messageGo to next message
aschreiber
Messages: 1
Registered: November 2005
Junior Member
Bingo! This solution worked for me too. I was having the same problem.

Thanks!
Re: ORA-01007: variable not in select list [message #226910 is a reply to message #15311] Mon, 26 March 2007 22:10 Go to previous messageGo to next message
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?


Re: ORA-01007: variable not in select list [message #226947 is a reply to message #226910] Tue, 27 March 2007 00:23 Go to previous messageGo to next message
Frank
Messages: 7880
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)
Re: ORA-01007: variable not in select list [message #227023 is a reply to message #226947] Tue, 27 March 2007 02:51 Go to previous message
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
Previous Topic: Help with String (Instr)
Next Topic: Help with truncating minutes
Goto Forum:
  


Current Time: Sat Dec 10 16:38:17 CST 2016

Total time taken to generate the page: 0.07468 seconds