Hi You can't refer an object like that, you need to make the update as an dynamic sql like: execute immediate x.table_name||' set trnx_date=null'; /Johan On Tue, 2006-01-24 at 02:33 -0800, raja rao wrote: > Hi Team, > when i am trying to execute the following pl/sql, i am getting the > below error: > DECLARE > CURSOR c1hs IS SELECT table_name FROM dba_tables > WHERE table_name like '%ADT_ACT_TRXMST' > AND owner = 'SPLIT_USER'; > BEGIN > FOR x in c1hs > loop > update x.table_name set trnx_date=null; > commit; > > END loop; > end; > > update x.table_name set trnx_date=null; > * > ERROR at line 13: > ORA-06550: line 13, column 10: > PL/SQL: ORA-00942: table or view does not exist > ORA-06550: line 13, column 1: > PL/SQL: SQL Statement ignored > > can someone help me on this; > Raj > > ______________________________________________________________________ > Yahoo! Photos > Got holiday prints? See all the ways to get quality prints in your > hands ASAP. -- //www.freelists.org/webpage/oracle-l