Unanswered: Positioned update in Dynamic SQL cursor
I have a situation where a table is being created in the procedure and therefore a dynamic cursor is defined over the table and a loop is defined to span through the records of this cursor.
In the loop a piece of code generates two columns which are supposed to be updated in the table that was created above. It would be very simple if I can perform a positioned update using the dynamic cursor but I get an error when I declare the dynamic cursor as it does not recognise the columns mentioned in the 'FOR UPDATE OF' (as the table is being created using dynamic SQL statement)
Is it possible to define a dynamic positioned update cursor using parameter markers (or some how) ?