Hi,
I have an oracle 8173 db on Sun Solaris 2.8 and a developer run some perl
script (using DBI and DBD). But the program repeatly generated oracle trace
file in udump dirctory. I looked at the file and it has the following info
again and again (I set the max dump file size to 5M, otherwise the trace
file would fill up the disk). I also looked at Oracle doc for "ORA-6540" and
it says it is due to some compiler error of db objects. I checked the db and
all objects are valid. Does this look like a program logic error to get into
inifite loop? Has anyone seend this before?
TIA.
Guang Mei
PS: here is part of the trace file:
*** 2003-02-14 20:11:07.766
*** SESSION ID:(14.17080) 2003-02-14 20:11:07.718
*********START PLSQL RUNTIME DUMP************
***Got ORA-6540 while running PLSQL***
ANONYMOUS BLOCK:
library unit=26ebcd18 line=2 opcode=228 static link=0 scope=0
FP=1ae583c PC=26485791 Page=0 AP=0 ST=1ae640c
DL0=1af7150 GF=1af71d0 DL1=1af718c DPF=1af71cc DS=2dec9460
Dump of static Frame info:
scope frame
-------- --------
1 1ae583c
Dump of dependent info:
DON library unit variable list instantiation
--- ------------ ------------- -------------
0 26ebcd18 1af71d0 1afc12c
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-------------------------------------
INSTANTIATION OBJECT: object=1afc12c
type="PL/SQL"[0] lock=2c076620 handle=26ebcd18 body=0 level=1
flags=FST[60] executions=0
REST OF INSTANTIATION OBJECT:
address=1afc178 size=72
ffffffff 00000000 01abc9d4 00000000 01af71e0 00000000 00000012 00120000
2fc4d24c 00000000 00000000 01ab8818 00000000 00000000 00000000 00000000
00000000 00000000
version=43123476 instantiation size=124
exception id error DON offset begin end DID
--------- ------ ----- ------ ------ ------ ------ ------
0 0 0 1 1082 510 1081
line pcode offset
-------- ------------
2 482
6 510
22 917
23 927
25 955
27 970
28 980
30 1008
32 1023
33 1033
35 1061
39 1082
40 1083
***********END PLSQL RUNTIME DUMP************
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
