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