MySQL Forums
Forum List  »  Stored Procedures

No data to FETCH warning
Posted by: Laurent
Date: October 27, 2005 06:53AM

Using the client I execute the following command

mysql> select * from artefacttype where name like 'project' //
+----------------+---------+
| ArtefactTypeId | Name |
+----------------+---------+
| 2 | project |
+----------------+---------+
1 row in set (0.00 sec)

When I execute a stored procedure containing the following code

select ArtefactTypeId into TypeId
from ArtefactType
where Name like 'project';

I get the warning "No data to FETCH ".

Why do I see a difference in behaviour between mysql cmd line and stored procedure?

L.

Options: ReplyQuote


Subject
Views
Written By
Posted
No data to FETCH warning
2450
October 27, 2005 06:53AM
1666
October 27, 2005 07:13AM


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.