plsql err
- From: raja rao <raja4list@xxxxxxxxx>
- To: oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 02:33:27 -0800 (PST)
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.
Other related posts:
