Re: Trying to use WHERE CURRENT OF CURSOR

"OracleNewbie" <rhythmram_at_gmail.com> wrote in message news:1135202900.834662.216270_at_g49g2000cwa.googlegroups.com...
> 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 row by EXECUTE IMMEDIATE WITH WHERE
> CURRENT OF CURSOR. <<ERROR>>
> Loop
> Cursor2 Loop End
> Loop
> Cursor1 Loop End
>
>
> 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
>

the error message says it all here's the syntax again:

EXECUTE IMMEDIATE dynamic_string

[INTO {define_variable[, define_variable]... | record}]

[USING [IN | OUT | IN OUT] bind_argument

[, [IN | OUT | IN OUT] bind_argument]...]

[{RETURNING | RETURN} INTO bind_argument[, bind_argument]...];

look up the explanation in the PL/SQL user's guide

++mcs Received on Thu Dec 22 2005 - 21:18:44 CET