MySQL Forums
Forum List  »  Oracle

Re: Cursor and Prepared statement
Posted by: Carol Nickel
Date: July 21, 2008 06:21PM

Unfortunately, it looks like prepare statements can't be used in cursors. From the manual:

"SQL syntax for prepared statements can be used within stored procedures, but not in stored functions or triggers. However, a cursor cannot be used for a dynamic statement that is prepared and executed with PREPARE and EXECUTE. The statement for a cursor is checked at cursor creation time, so the statement cannot be dynamic."

I would also be interested to know what the alternative is.

Options: ReplyQuote

Written By
September 19, 2006 02:32AM
June 02, 2008 03:56AM
Re: Cursor and Prepared statement
July 21, 2008 06:21PM
September 10, 2008 05:27PM

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.