Trying to use WHERE CURRENT OF CURSOR
From: OracleNewbie <rhythmram_at_gmail.com>
Date: 21 Dec 2005 14:08:20 -0800
Message-ID: <1135202900.834662.216270_at_g49g2000cwa.googlegroups.com>
This is my
requirement.
Say i have the following 5 tables.
Table1
Table2
Table3
Table4
Table5
Date: 21 Dec 2005 14:08:20 -0800
Message-ID: <1135202900.834662.216270_at_g49g2000cwa.googlegroups.com>
This is my
requirement.
Say i have the following 5 tables.
Table1
Table2
Table3
Table4
Table5
- There will be a column called "XYZ" on all the 5 tables.
- I need to update this column "XYZ" on certain tables based on [Quoted] 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 Received on Wed Dec 21 2005 - 23:08:20 CET