Re: need help....
Seems from the error message that your using select into using a query that might be returning more than one row. Try using the limit clause to return just a single row.
Perhaps the first time it ran it returned the single row and then it added a row which would then result in the error.
Check out my website, I have examples of using select into.
http://www.mysqldevelopment.com
Can you post the procedure your using.
Andrew Gilfrin
http://www.mysqldevelopment.com
Subject
Written By
Posted
February 15, 2005 06:06AM
Re: need help....
February 15, 2005 03:32PM
February 15, 2005 11:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.