Re: Execute Immediate Not Working With WHERE CURRENT OF

[Quoted] rhythmram_at_gmail.com wrote:
> Hi Daniel,
> I think i didn't posted the question correctly. This is my
> requirement.
> Say i have the following 5 tables.
> Table1
> Table2
> Table3
> Table4
> Table5
>
> 1. There will be a column called "XYZ" on all the 5 tables.
> 2. I need to update this column "XYZ" on certain tables based on
> the user input to the oracle function.
>
> Fucntion (Input)
> Logic to find the list of tables needed to be updated.
> I have the list of tables in a cursor
>
> Cursor1 Loop Start
> For Each Table
> Some logic to select only particular rows in that table
> I have the list of rows in a cursor
> Cursor2 Loop Start
> For Each Row
> Some logic to get the value for "XYZ" column for each row
> Update each
> Loop
> Cursor2 Loop End
> Loop
> Cursor1 Loop End
>
> hope you got my problem
> So I'm try to use Execute Immendiate along with where current of for
> the above. And i'm getting the ORA-03001: unimplemented feature error

IF <some condition> THEN

   do these updates
ELSIF <some other condition> THEN

   do these updates
ELSE
   do something else
END IF; Are you working on Project Titanic? Seems like it as this design looks like it will sink on its maiden voyage.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)