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
|
|
|
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.
|
|
|
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
|
|
|
|
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?
|
|
|
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)
|
|
|
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
|
|
|