You would generate sql commands on the fly ; Subsequently you can do either of the following: 1. Either spool them out and run them separately 2. Store them in a varchar2 variable and execute the string 3. Execute immediate .. update :tname set :cname = :value using parm1 , parm2 , parm3. HTH GovindanK Certified DBA On Tue, 24 Jan 2006 02:33:27 -0800 (PST), "raja rao" <raja4list@xxxxxxxxx> said: > 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 > > -- //www.freelists.org/webpage/oracle-l