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].
Subject
Views
Written By
Posted
get result of executing prepared statement
4590
May 11, 2015 07:58AM
1516
May 11, 2015 11:15PM
1276
May 12, 2015 04:52AM
1256
May 12, 2015 11:16AM
1169
May 13, 2015 09:58AM
1272
May 13, 2015 10:39AM
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.