MySQL Forums
Forum List  »  Stored Procedures

Calling procedure in the select clause
Posted by: Jed Walker
Date: June 25, 2014 06:16PM

Hi,
I want to call a procedure for every row I retrieve via a query, but without having to write a stored procedure to do that.
Here is what I get (names changed to protect the innocent):
mydb> select test('this',7,obj_id,'that',response_time,null) from tbl1 where <whatever> order by ts;
ERROR 1305 (42000): FUNCTION mydb.test does not exist
Based on the error and logic, it would seem it has to be a function to use here, but I'm wondering if there is some way to get a procedure to work in this case, so I don't have to convert it to a function and then modify and re-test everything that relies on it.

Options: ReplyQuote


Subject
Views
Written By
Posted
Calling procedure in the select clause
2308
June 25, 2014 06:16PM


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.