Wow, time flies. You've inspired me to order the fourth edition just now as I've been using the first edition (September 1995) for the last 10 years. I guess I've gotten my money's worth. Jay Miller -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Sent: Tuesday, January 24, 2006 2:08 PM To: raja4list@xxxxxxxxx Cc: oracle list Subject: Re: plsql err 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 <http://us.rd.yahoo.com/mail_us/taglines/holidayprints/*http:/pa.yahoo.c om/*http:/us.rd.yahoo.com/mail_us/taglines/photos/evt=38089/*http:/pg.ph otos.yahoo.com/ph/print_splash> the ways to get quality prints in your hands ASAP. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ----------------------------------------- This message is confidential and sent by TD Waterhouse solely for use by the intended recipient. If you are not the intended recipient, you are hereby notified that any use, distribution or copying of this communication is strictly prohibited. This should not be deemed as an offer or solicitation, to buy or sell any product. Any 3rd party information contained herein was prepared by sources deemed reliable, but is not guaranteed. TD Waterhouse does not accept electronic instructions that would require an original signature. Information received by or sent from TD Waterhouse is stored, subject to review, and may be produced to regulatory authorities or others with a legal right to such.