plsql err 2006-01-24 - By Jared Still
Raj,
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>
|
|
