Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> plsql err
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
![]() |
![]() |