Raj, You need to buy this book: http://www.oreilly.com/catalog/oraclep4/ It will help you immensely. I've been relying on it (and subsequent versions) since about 1995. Jared On 1/24/06, raja rao <raja4list@xxxxxxxxx> 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<http://us.rd.yahoo.com/mail_us/taglines/holidayprints/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt=38089/*http://pg.photos.yahoo.com/ph//print_splash>to > get quality prints in your hands ASAP. > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist