plsql err

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

plsql err

plsql err

2006-01-24 - By JayMiller@(protected)

Reply: 1 2 3 4 5 6

Wow, time flies. You've inspired me to order the fourth edition just
now as I've been using the first edition (September 1995) for the last
10 years. I guess I've gotten my money's worth.

Jay Miller

-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]
Sent: Tuesday, January 24, 2006 2:08 PM
To: raja4list@(protected)
Cc: oracle list
Subject: Re: plsql err

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
<http://us.rd.yahoo.com/mail_us/taglines/holidayprints/*http:/pa.yahoo.c
om/*http:/us.rd.yahoo.com/mail_us/taglines/photos/evt=38089/*http:/pg.ph
otos.yahoo.com/ph/print_splash> the ways to get quality prints in your
hands ASAP.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

-- ---- ---- ---- ---- ---- ---- ---- ---
This message is confidential and sent by TD Waterhouse solely for
use by the intended recipient. If you are not the intended
recipient, you are hereby notified that any use, distribution or
copying of this communication is strictly prohibited. This should
not be deemed as an offer or solicitation, to buy or sell any
product. Any 3rd party information contained herein was prepared by
sources deemed reliable, but is not guaranteed. TD Waterhouse does
not accept electronic instructions that would require an original
signature. Information received by or sent from TD Waterhouse is
stored, subject to review, and may be produced to regulatory
authorities or others with a legal right to such.

<HTML>
<BODY>
<html>

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">

<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>

</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

Wow, time flies.  You’ve
inspired me
to order the fourth edition just now as I’ve been using the first edition
(September 1995) for the last 10 years.  I guess I’ve gotten my
money’s
worth.

 

<div>

Jay Miller

 

</div>

 

-- --Original Message-- -- 
From:
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] 
Sent: Tuesday,
January 24, 2006 2:08 PM 
To: raja4list@(protected) 
Cc: oracle list 
Subject: Re: plsql err

 

Raj,
 
 
You need to buy this book: 
<a href="http://www.oreilly.com/catalog/oraclep4/">http://www.oreilly.com
/catalog/oraclep4/</a> 
 
It will help you immensely. 
 
I've been relying on it (and subsequent versions) since about 1995. 
 
Jared

<div>

On 1/24/06, 
raja rao <<a
href="mailto:raja4list@(protected)">raja4list@(protected)</a>> wrote:

<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
 
  WHERE table_name like '%ADT_ACT_TRXMST' 
  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; 
commit;

</div>

<div>

 
END loop;

</div>

<div>

end;

</div>

<div>

 
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 

</div>

<div>

 
can someone help me on this;

</div>

<div>

Raj

</div>

<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'>


<hr size=1 width="100%" align=center>

</div>

Yahoo! Photos 
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. 

</div>

 
 
 
-- 
Jared Still 
Certifiable Oracle DBA and Part Time Perl Evangelist

</div>

</body>

</html>

<hr size=1>

This message is confidential and sent by TD Waterhouse solely for 
use by the intended recipient. If you are not the intended 
recipient, you are hereby notified that any use, distribution or 
copying of this communication is strictly prohibited. This should 
not be deemed as an offer or solicitation, to buy or sell any 
product. Any 3rd party information contained herein was prepared by 
sources deemed reliable, but is not guaranteed. TD Waterhouse does 
not accept electronic instructions that would require an original 
signature. Information received by or sent from TD Waterhouse is 
stored, subject to review, and may be produced to regulatory 
authorities or others with a legal right to such.

</BODY>
</HTML>