plsql err 2006-01-24 - By raja rao
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 (See ORA-06550.ora-code.com): line 13, column 10:
PL/SQL: ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist
ORA-06550 (See ORA-06550.ora-code.com): 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.
<DIV id=RTEContent>Hi Team,</DIV> <DIV>when i am trying to execute the
following pl/sql, i am getting the below error:</DIV> <DIV>DECLARE</DIV> <DIV
>CURSOR c1hs IS SELECT table_name FROM dba_tables <BR> WHERE table
_name like '%ADT_ACT_TRXMST' <BR> AND owner
= 'SPLIT_USER';</DIV> <DIV>BEGIN</DIV> <DIV>FOR x in c1hs </DIV>
<DIV>loop</DIV> <DIV>update x.table_name set trnx_date=null;<BR>commit;</DIV>
<DIV><BR>END loop;</DIV> <DIV>end;</DIV> <DIV><BR>update x.table_name set
trnx_date=null;<BR> *<BR>ERROR
at line 13:<BR>ORA-06550 (See ORA-06550.ora-code.com): line 13, column 10:<BR>PL/SQL: ORA-00942 (See ORA-00942.ora-code.com): table or
view does not exist<BR>ORA-06550 (See ORA-06550.ora-code.com): line 13, column 1:<BR>PL/SQL: SQL Statement
ignored</DIV> <DIV><BR>can someone help me on this;</DIV> <DIV>Raj</DIV><p>
<hr size=1>Yahoo! Photos<br>
Got holiday prints? <a href="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">See all the ways
</a> to get quality prints in your hands ASAP.
|
|
