oracle 错误 04020,ora-04020的错误

Argument/Register addr=48ef80.

Dump of memory from 0x48EF40 to 0x48F080

48EF40 64013B3A 002C158B 3C8B0000 8D068B8A  [:;.d..,....<....>

48EF50 048D800C 80148D48 3A0CA8A1 901C8D01  [....H......:....]

48EF60 156C878B C0850000 B6680F74 E8000027  [..l.....t.h.'...]

48EF70 FFFF0D5C EB04C483 85C03302 8B4A74C0  [\........3...tJ.]

48EF80 438B1853 784B8D14 520B8B51 0CA8158B  [S..C..KxQ..R....]

48EF90 5150013A 95B8CB8B 2B094F20 C1E9F7CA  [:.PQ.... O.+....]

48EFA0 C28B03FA 8B66C933 E8C1064B 8BD0031F  [....3.f.K.......]

48EFB0 33522043 538B66D2 50525104 E27CD868  [C R3.f.S.QRPh.|.]

48EFC0 F22AE800 C483FFF8 5643F624 8B377402  [..*.....$.CV.t7.]

48EFD0 3A017815 66C93301 8B044B8B F6FC8A44  [.x.:.3.f.K..D...]

48EFE0 74010140 EC80F61A 28000004 8B661175  [@..t.......(u.f.]

48EFF0 3B66064B 0004C688 33047500 B824EBC0  [K.f;.....u.3..$.]

48F000 00000001 538B1DEB 091CA120 5052013A  [.......S ...:.RP]

48F010 22A14BE8 012CB900 C4830000 1BC83B08  [.K."..,......;..]

48F020 85D8F7C0 8B2674C0 C0851443 433B0574  [.....t&.C...t.;C]

48F030 8B1A7418 16894216 0CA00D8B C28B013A  [.t...B......:...]

48F040 8C0FC13B FFFFFF05 5D8B03EB A0158B10  [;..........]....]

48F050 8B013A0C 7CC23B06 5FC03309 E58B5B5E  [.:...;.|.3._^[..]

48F060 8B66C35D 89660443 8B660446 8966064B  [].f.C.f.F.f.K.f.]

48F070 538B064E 0856892C 8930438B 8B660C46  [N..S,.V..C0.F.f.]

Argument/Register addr=3c48ef80.

Dump of memory from 0x3C48EF40 to 0x3C48F080

3C48EF40 00000005 3C4CF8BC 3C4CFA60 3C48EF6C  [......L

3C48EF50 60B175F8 00000005 0000000B 3C48EFF0  [.u.`..........H

3C48EF60 3C48EF84 60B1737D 3C4CF8BC 0000000B  [..H

3C48EF70 0000000A 3C48EF97 0000000B 3C48EFF0  [......H<......h>

3C48EF80 00000C29 00000000 3C48E444 000000E1  [).......D.H<....>

3C48EF90 3C48E41C 00000009 3C51626C 3C48EDE0  [..H<....lbq>

3C48EFA0 00000000 00000000 00000000 3C48E354  [............T.H

3C48EFB0 00000007 00000000 00000000 3C48EE10  [..............H

3C48EFC0 00000000 3C48EE28 00000000 00000000  [....(.H<........>

3C48EFD0 00000000 00000000 00000000 00000000  [................]

Repeat 10 times

Argument/Register addr=3c48fbf8.

Dump of memory from 0x3C48FBB8 to 0x3C48FCF8

3C48FBB0                   3C48FBEC 001F0003          [..H<....>

3C48FBC0 3C48FBCC 3C4C4AFC 60840538 00000000  [..H<.jl>

3C48FBD0 00000000 3C000000 00000000 00000000  [.......<........>

3C48FBE0 00000000 00380036 00000000 00000910  [....6.8.........]

3C48FBF0 3C48FC10 77E71266 3C48FD80 FFFFFFFF  [..H

3C48FC00 00000000 00000001 00000000 3C48FE88  [..............H

3C48FC10 77E67738 3C48FFB4 00403154 00000002  [8w.w..H

3C48FC20 3C48FE74 01298BFC 786F9638 01299088  [t.H<..>

3C48FC30 446C3A00 004000C0 74F5721A 3C48FC88  [.:lD..@..r.t..H

3C48FC40 77F8C4F4 00400000 00000001 00000009  [...w..@.........]

3C48FC50 00000000 44414853 00000000 74F50000  [....SHAD.......t]

3C48FC60 00000002 011DD738 00000000 00002A10  [....8........*..]

3C48FC70 3C48FC54 002C4004 3C48FD0C 77F82B95  [T.H<.>

3C48FC80 77F8C538 FFFFFFFF 3C48FD1C 77F8C696  [8..w......H<...w>

3C48FC90 00400000 00000002 7FFDF000 7FF3E000  [..@.............]

3C48FCA0 77F867D0 77FCF348 77F8674E 3C48FD30  [.g.wH..wNg.w0.H

3C48FCB0 786F9638 01299088 00000000 00000000  [8.ox..).........]

3C48FCC0 00000000 00000000 00000000 00000000  [................]

Repeat 2 times

3C48FCF0 00000000 7FF3E000                    [........]

Argument/Register addr=3c48fe74.

Dump of memory from 0x3C48FE34 to 0x3C48FF74

3C48FE30          861699E8 00000700 8044CDD4      [..........D.]

3C48FE40 00021DBF 861699E8 00021DBF 861699E8  [................]

3C48FE50 7FF0F201 85DF44E4 00000002 8042C31E  [.....D........B.]

3C48FE60 00000001 F4E34BA4 00000000 F4E34B84  [.....K.......K..]

3C48FE70 8044DAC1 3C48FD74 3C48FD80 00000000  [..D.t.H<..h>

3C48FE80 C01FFC3C 00000000 61726F2A 77617073  [<.......>

3C48FE90 65725F6E 5F796C70 61656473 37325F6D  [n_reply_sdeam_27]

3C48FEA0 002A3233 7FF0F000 8395D4A8 856E4A01  [32*..........Jn.]

3C48FEB0 00000000 C01FFC3C 8042D285 800651DD  [....<.....b..q..>

3C48FEC0 85D033C4 F4E34D01 00000001 80483518  [.3...M.......5H.]

3C48FED0 85E324A0 85DE6120 804329BF 80483510  [.$.. a...)C..5H.]

3C48FEE0 85DE6120 80432B2B 0000000A 0000000E  [ a..++C.........]

3C48FEF0 7FF0F000 85A5A500 0000000A 00000000  [................]

3C48FF00 00000000 00000000 85ACB2B0 FFFFFFFF  [................]

3C48FF10 856E49A0 00000000 FF4F7480 85DEE000  [.In......tO.....]

3C48FF20 85DEF000 00000000 80064C4F 00000008  [........OL......]

3C48FF30 856E49A0 FF4F7480 00000000 FF4F74EC  [.In..tO......tO.]

3C48FF40 FF4F7480 FF4F7610 8042BFC7 FF4F7480  [.tO..vO...B..tO.]

3C48FF50 FF4F75E0 800654F0 00000246 8046A499  [.uO..T..F.....F.]

3C48FF60 F4E34C70 00000000 00000000 F4E34CB0  [pL...........L..]

3C48FF70 00000000                             [....]

----- End of Call Stack Trace -----

===================================================

Files currently opened by this process:

===================================================

PROCESS STATE

-------------

Process global information:

process: e8e5214, call: a901588, xact: ee1f364, curses: e90064c, usrses: e90064c

----------------------------------------

SO: e8e5214, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00

(process) Oracle pid=134, calls cur/top: a901588/a901588, flag: (0) -

int error: 0, call error: 0, sess error: 0, txn error 0

(post info) last post received: 0 0 4

last post received-location: kslpsr

last process to post me: e8cb7c4 1 2

last post sent: 0 0 13

last post sent-location: ksasnd

last process posted by me: e8cb7c4 1 2

(latch info) wait_event=0 bits=0

Process Group: DEFAULT, pseudo proc: e8f2278

O/S info: user: SYSTEM, term: EAM-SERVER-A, ospid: 2732

OSD pid info: 2732

----------------------------------------

SO: e90064c, type: 3, owner: e8e5214, pt: 0, flag: INIT/-/-/0x00

(session) trans: ee1f364, creator: e8e5214, flag: (41) USR/- BSY/-/-/-/-/-

DID: 0001-0086-00000002, short-term DID: 0000-0000-00000000

txn branch: 0

oct: 2, prv: 0, user: 72/SDTRAINING

O/S info: user: lhq, term: LHQ_MOBILE, ospid: 2160:1768, machine: WORKGROUP\LHQ_MOBILE

program:

last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1430 wait_time=-2

driver id=28444553, #bytes=1, =0

----------------------------------------

SO: 5488220, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=5488220 handle=c257900 mode=N

call pin=abbe6dc session pin=0

user=e90064c session=e90064c count=1 flags=[00] savepoint=14412

LIBRARY OBJECT HANDLE: handle=c257900

name=SDTRAINING.POSINS_STR

hash=d55ad717 timestamp=08-18-2002 02:41:33

namespace=TRGR flags=KGHP/TIM/SML/[02000000]

kkkk-dddd-llll=0000-0059-0059 lock=N pin=0 latch=2

lwt=c257918[c257918,c257918] ltm=c257920[c257920,c257920]

pwt=c257930[c257930,c257930] ptm=c257988[c257988,c257988]

ref=c257908[c257908,c257908] lnd=c257994[da09cc4,92744b0]

LIBRARY OBJECT: object=d39e300

type=TRGR flags=EXS/LOC[0005] pflags= [00] status=VALD load=0

DEPENDENCIES: count=4 size=16

ACCESSES: count=2 size=16

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  d39e42c  c25782c I/-/A     0 NONE

3  d39e394        0 -/P/-     0 NONE

4  c25777c  728b304 I/-/A     0 NONE

6  c2577dc  c1f3bb0 I/-/A     0 NONE

----------------------------------------

SO: a9cbe24, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=a9cbe24 handle=4abffec mode=N

call pin=a81f7f0 session pin=0

user=e90064c session=e90064c count=1 flags=[00] savepoint=14412

LIBRARY OBJECT HANDLE: handle=4abffec

name=SDTRAINING.PREINS_STR

hash=e8c9eb24 timestamp=08-18-2002 02:42:25

namespace=TRGR flags=KGHP/TIM/SML/[02000000]

kkkk-dddd-llll=0000-0059-0059 lock=N pin=0 latch=0

lwt=4ac0004[4ac0004,4ac0004] ltm=4ac000c[4ac000c,4ac000c]

pwt=4ac001c[4ac001c,4ac001c] ptm=4ac0074[4ac0074,4ac0074]

ref=4abfff4[4abfff4,4abfff4] lnd=4ac0080[39363d0,4ace5c8]

LIBRARY OBJECT: object=65403ec

type=TRGR flags=EXS/LOC[0005] pflags= [00] status=VALD load=0

DEPENDENCIES: count=5 size=16

ACCESSES: count=3 size=16

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  65405f4  6540590 I/-/A     0 NONE

3  6540480        0 -/P/-     0 NONE

4  65404e0  c368700 I/-/A     0 NONE

6  6540540  c176aa8 I/-/A     0 NONE

----------------------------------------

SO: a83a040, type: 36, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT PIN: pin=a83a040 handle=4884d9c mode=S lock=57fb490

user=e90064c session=e90064c count=1 mask=0041 savepoint=14411 flags=[00]

----------------------------------------

SO: 57fb490, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=57fb490 handle=4884d9c mode=N

call pin=0 session pin=a83a040

user=e90064c session=e90064c count=1 flags=BRO/PNS/[09] savepoint=3168

LIBRARY OBJECT HANDLE: handle=4884d9c

namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]

kkkk-dddd-llll=0000-0041-0041 lock=0 pin=S latch=4

lwt=4884db4[4884db4,4884db4] ltm=4884dbc[57fb4a0,57fb4a0]

pwt=4884dcc[4884dcc,4884dcc] ptm=4884e24[4884e24,4884e24]

ref=4884da4[c2a9470,c2a9470] lnd=4884e30[4884e30,4884e30]

LIBRARY OBJECT: object=cd34d78

type=CRSR flags=EXS[0001] pflags= [00] status=INVL load=0

DEPENDENCIES: count=23 size=32

ACCESSES: count=2 size=16

TRANSLATIONS: count=1 size=16

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  cd34f80  6531e24 I/P/A     0 NONE

6  cd34e0c  c07e4ac I/P/A     1 NONE

----------------------------------------

SO: a9bd88c, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=a9bd88c handle=529f3f8 mode=N

call pin=abd016c session pin=0

user=e90064c session=e90064c count=1 flags=[00] savepoint=3168

LIBRARY OBJECT HANDLE: handle=529f3f8

name=

INSERT INTO R5STORES

(STR_CODE, STR_DESC, STR_AUTOAPPVSTATUS, STR_ORG, STR_COPY, STR_LOCATION_ORG)

VALUES

(:STR_CODE, :STR_DESC, :STR_AUTOAPPVSTATUS, :STR_ORG, :STR_COPY, :STR_LOCATION_ORG)

RETURNING ROWID INTO

OA__ROWID

hash=b6c94549 timestamp=07-14-2003 16:25:01

namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]

kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=4

lwt=529f410[529f410,529f410] ltm=529f418[529f418,529f418]

pwt=529f428[529f428,529f428] ptm=529f480[529f480,529f480]

ref=529f400[529f400,529f400] lnd=529f48c[529f48c,529f48c]

LIBRARY OBJECT: object=c2a92e8

type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0

CHILDREN: size=16

child#    table reference   handle

------ -------- --------- --------

0  c2a94a4   c2a9470  4884d9c

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  c2ac978  c2a936c I/P/A     0 NONE

----------------------------------------

SO: ee1f364, type: 25, owner: e90064c, pt: 0, flag: INIT/-/-/0x00

(trans) bsn = 3165, flg = 0x01, flg2 = 0x00, prx = 0x0, ros = 2147483647, spn = 14413

efd = 6

parent xid: 0x0000.000.00000000

env: (scn: 0x0000.00000000  xid: 0x0000.000.00000000  uba: 0x00000000.0000.00)

cev: (spc = 0  usi = 2147483647  ubk tsn: 0 rdba: 0x00000000  useg tsn: 0 rdba: 0x00000000

hwm uba: 0x00000000.0000.00  col uba: 0x00000000.0000.00

num bl: 0 bk list: 0x0)

(enqueue)

res: 0, prv: 0, sess: 0

xga: 0x60c920c, heap: UGA

----------------------------------------

SO: ede7c0c, type: 22, owner: ee1f364, pt: 0, flag: INIT/-/-/0x00

DML LOCK: tab=61434 flg=01 chi=0

his[0]: mod=3 spn=14412

(enqueue) TM-0000EFFA-00000000        DID: 0001-0086-00000002

lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

res: e9e16f8, mode: SX, prv: e9e1700, sess: e90064c, proc: e8e5214

----------------------------------------

SO: aa3b6f0, type: 36, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT PIN: pin=aa3b6f0 handle=0 lock=a8ea654

user=e90064c session=e90064c count=0 mask=0000 savepoint=3163 flags=[00]

----------------------------------------

SO: a8ea654, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=a8ea654 handle=a61b7f8 mode=N

call pin=0 session pin=aa3b6f0

user=e90064c session=e90064c count=1 flags=[00] savepoint=3162

LIBRARY OBJECT HANDLE: handle=a61b7f8

namespace=CRSR flags=RON/KGHP/PN0/[10010000]

kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=3

lwt=a61b810[a61b810,a61b810] ltm=a61b818[a61b818,a61b818]

pwt=a61b828[a61b828,a61b828] ptm=a61b880[a61b880,a61b880]

ref=a61b800[6633a04,6633a04] lnd=a61b88c[a61b88c,a61b88c]

LIBRARY OBJECT: object=4df6d10

type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0

SCHEMA: count=1 size=16 entrysize=4

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  4ded668  31382a4 I/P/A     0 NONE

6  4df6da4  d6ae240 I/-/A     0 NONE

----------------------------------------

SO: abf5bcc, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=abf5bcc handle=6d8f3b0 mode=N

call pin=54d7194 session pin=0

user=e90064c session=e90064c count=1 flags=[00] savepoint=3162

LIBRARY OBJECT HANDLE: handle=6d8f3b0

name=SAVEPOINT DOA__LOCKPOINT

hash=482e0197 timestamp=07-14-2003 10:58:15

namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]

kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=3

lwt=6d8f3c8[6d8f3c8,6d8f3c8] ltm=6d8f3d0[6d8f3d0,6d8f3d0]

pwt=6d8f3e0[6d8f3e0,6d8f3e0] ptm=6d8f438[6d8f438,6d8f438]

ref=6d8f3b8[6d8f3b8,6d8f3b8] lnd=6d8f444[6d8f444,6d8f444]

LIBRARY OBJECT: object=663387c

type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0

CHILDREN: size=16

child#    table reference   handle

------ -------- --------- --------

0  6633a38   6633a04  a61b7f8

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  6633a84  6633900 I/P/A     0 NONE

----------------------------------------

SO: a9d609c, type: 36, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT PIN: pin=a9d609c handle=c1745cc mode=S lock=a9e310c

user=e90064c session=e90064c count=1 mask=0041 savepoint=2505 flags=[00]

----------------------------------------

SO: a9e310c, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=a9e310c handle=c1745cc mode=N

call pin=0 session pin=a9d609c

user=e90064c session=e90064c count=1 flags=BRO/PNS/[09] savepoint=2505

LIBRARY OBJECT HANDLE: handle=c1745cc

namespace=CRSR flags=RON/KGHP/FUL/PN0/[14010000]

kkkk-dddd-llll=0000-0041-0041 lock=0 pin=S latch=0

lwt=c1745e4[c1745e4,c1745e4] ltm=c1745ec[a9e311c,a9e311c]

pwt=c1745fc[c1745fc,c1745fc] ptm=c174654[c174654,c174654]

ref=c1745d4[51a304c,51a304c] lnd=c174660[c174660,c174660]

LIBRARY OBJECT: object=52cfafc

type=CRSR flags=EXS[0001] pflags= [00] status=INVL load=0

DEPENDENCIES: count=1 size=16

ACCESSES: count=1 size=16

TRANSLATIONS: count=1 size=16

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  52cfd04  c245a84 I/P/A     0 NONE

6  52cfb90  c237f84 I/P/A     1 NONE

----------------------------------------

SO: aba4a20, type: 35, owner: e90064c, flag: INIT/-/-/0x00

LIBRARY OBJECT LOCK: lock=aba4a20 handle=da50218 mode=N

call pin=ab10c54 session pin=0

user=e90064c session=e90064c count=1 flags=[00] savepoint=2505

LIBRARY OBJECT HANDLE: handle=da50218

name=SELECT rowid, "R5STORES".* FROM "R5STORES"

hash=31cf563d timestamp=07-14-2003 16:23:58

namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]

kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0

lwt=da50230[da50230,da50230] ltm=da50238[da50238,da50238]

pwt=da50248[da50248,da50248] ptm=da502a0[da502a0,da502a0]

ref=da50220[da50220,da50220] lnd=da502ac[da502ac,da502ac]

LIBRARY OBJECT: object=51a2ec4

type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0

CHILDREN: size=16

child#    table reference   handle

------ -------- --------- --------

0  51a3080   51a304c  c1745cc

DATA BLOCKS:

data#     heap  pointer status pins change

----- -------- -------- ------ ---- ------

0  51b72a8  51a2f48 I/P/A     0 NONE

----------------------------------------

SO: a936a64, type: 36, owner: e90064c, flag: INIT/-/-/0x00