Oracle-L: perl script generating oracle udump trace file

From: Guang Mei <zlmei_at_hotmail.com>
Date: Sun, 16 Feb 2003 14:03:40 -0800
Message-ID: <F001.0054EF42.20030216140340@fatcity.com>

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: zlmei_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Received on Sun Feb 16 2003 - 16:03:40 CST