You need to buy this book: http://www.oreilly.com/catalog/oraclep4/
It will help you immensely.
I've been relying on it (and subsequent versions) since about 1995.
Jared
On 1/24/06, raja rao <raja4list@(protected)> wrote: > > 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<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>to get quality prints in your hands ASAP. > >
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
Raj,<br><br>You need to buy this book:<br><a href="http://www.oreilly.com /catalog/oraclep4/">http://www.oreilly.com/catalog/oraclep4/</a><br><br>It will help you immensely.<br><br>I've been relying on it (and subsequent versions) since about 1995. <br><br>Jared<br><br><div><span class="gmail_quote">On 1/24/06, <b class="gmail _sendername">raja rao</b> <<a href="mailto:raja4list@(protected)">raja4list @(protected)</a>> wrote:</span><blockquote class="gmail_quote" style="border -left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div>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><span class= "ad"><p>
</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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> See all the ways</a> to get quality prints in your hands ASAP. <p></p></span></blockquote></div><br><br clear="all"><br>-- <br>Jared Still<br >Certifiable Oracle DBA and Part Time Perl Evangelist<br>
