MySQL Forums
Forum List  »  Stored Procedures

get result of executing prepared statement
Posted by: Tom Byars
Date: May 11, 2015 07:58AM

Is there a way of retrieving the result of executing a prepared statement within a stored procedure or function?

i.e. the equivalent of

select x from Tbl where .... limit 1 into SomeVariable;

execute PreparedStatement using @v into SomeVariable;

doesn't work.

[Apologies for originally posting this problem in the UDF forum].

Options: ReplyQuote

Written By
get result of executing prepared statement
May 11, 2015 07:58AM

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.