plsql err

From: raja rao <raja4list_at_yahoo.com>
Date: Tue, 24 Jan 2006 02:33:27 -0800 (PST)
Message-ID: <20060124103327.21245.qmail@web31402.mail.mud.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 24 2006 - 04:33:27 CST