Добрый день!
База 11.2.0.1.0
При выполнении запроса в триггере возникает ошибка
1.
ORA-07445: exception encountered: core dump [PGOSF544_upduaw()+3395] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x414E0BD] [UNABLE_TO_READ] []
Полный текст
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
Dump continued from file: d:\oracle11gr2\app\programmer\diag\rdbms\prg\prg\trace\prg_ora_3936.trc
ORA-07445: exception encountered: core dump [PGOSF544_upduaw()+3395] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x414E0BD] [UNABLE_TO_READ] []
========= Dump for incident 25611 (ORA 7445 [PGOSF544_upduaw()+3395]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0] [PC:0x414E0BD, __PGOSF544_upduaw()+3395]
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Process Id: 0x00000e8c Thread Id : 0x00000f60 Time : Thu Dec 16 23:31:26
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000
------------------- Registers ----------------------------
ip=000000000414E0BD sp=0000000035A7E780 rp=00000000322A26F8
r1=0000000000000005 r2=00000000322B6F40 r3=00000000322A2760
r4=0000000000000000 r5=0000000035A7E780 r6=00000000322A26F8 r7=00000000322A22C0
r8=0000000000000000 r9=0000000000000004 r10=00000000000000FF r11=0000000000000000
r12=00007FF66EA43CF8 r13=00007FF65B266230 r14=000000001233BA90 r15=0000000000000004
------------------- End of Registers ---------------------
*** 2021-12-16 23:31:26.349
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=d48239ntrhc56) -----
UPDATE OBJGR SET ISTRACEABLE = :B2 WHERE UPPER(NAME) = UPPER(:B1 ) AND OBJGRLISTID IN (SELECT ID FROM OBJGRLIST WHERE (MANDATORY = :B5 ) AND (OWNGROUPSFORBIDDEN = :B4 ) AND (ID <> :B3 ) )
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
00007FF68C11C4F8 866 package body ELSNORM.NP
00007FF68C262A98 388 package body ELSNORM.NTT
00007FF6768A29D0 5 ELSNORM.OBJGR_AIUDT
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
__PGOSF544_upduaw() 0000000000000000 035A60C10 06D153F69 00D587390
+3395 00D584220
kdusru()+652 CALL??? __PGOSF544_upduaw() 000000000 01233BA90 000000000
000000000
kauupd()+526 CALL??? kdusru() 7FF6FFFFFFFF 01233BA90
000000007 001F08C03
updrow()+2862 CALL??? kauupd() 0322BDFF0 7FF66EA43498
0322A22C0 000000000
qerupFetch()+962 CALL??? updrow()+1472 7FF675546BD8 7FF600007FFF
000000000 000000001
updaul()+1658 CALL??? qerupFetch() 7FF65B266668 0322A20B8
000000000 000000000
updThreePhaseExe()+ CALL??? updaul() 7FF675546BD8 035A839C0
412 000000000 7FF600000000
updexe()+654 CALL??? updThreePhaseExe() 000000010 000000000 000000010
00A2BE6F3
opiexe()+19564 CALL??? updexe() 0322A0580 27F00000003
000000102 000000000
opipls()+3557 CALL??? opiexe()+16981 000000004 000000005 035A855C0
000000004
opiodr()+1662 CALL??? opipls()+3146 000000066 100AB00000007
035A87178 000000335
rpidrus()+862 CALL??? opiodr() 000000066 000000007 035A87178
000000004
rpidru()+154 CALL??? rpidrus() 035A86548 000020C80 000000200
4154535F534D4244
rpiswu2()+2757 CALL??? rpidru() 035A86DD0 0323323E8 02E125088
000021CE8
rpidrv()+6105 CALL??? rpiswu2() 7FF697603590 7FF600000056
7FF697603614 7FF600000002
psddr0()+614 CALL??? rpidrv() 000000004 000000066 035A87178
000000038
psdnal()+510 CALL??? psddr0() 000000004 27F00000066
035A87178 000000030
pevm_EXECC()+365 CALL??? psdnal() 01233C050 000000038 00A31213A
035A87268
pfrinstr_EXECC()+90 CALL??? pevm_EXECC() 000000001 0322CE180 02E12CEF0
00AE09C56
pfrrun_no_tool()+65 CALL??? pfrinstr_EXECC() 035A87758 7FF65BA10DD2
0322C73F0 7FF600000000
pfrrun()+1241 CALL??? pfrrun_no_tool() 000000000 0004D112F 0322DC068
01233C050
plsql_run()+875 CALL??? pfrrun() 0323323E8 7FF675126B00
7FF675126B00 0322A4DD0
peicnt()+329 CALL??? plsql_run() 0323323E8 0127C0001 000000000
035A87E40
peiet_execute_trigg CALL??? peicnt() 0322A02D8 0323323E8 000000000
er()+47 000000000
kkxtexe()+492 CALL??? peiet_execute_trigg 0322A02D8 7FF6768A29D0
er() 000000000 000000000
kxtExecuteTriggerRe CALL??? kkxtexe() 000000000 01233C050 035A88520
cursive()+625 000000000
rpiswu2()+2757 CALL??? kxtExecuteTriggerRe 0322A0218 00290E135 0127C2770
cursive() 01233C050
kxtExecuteTriggerRe CALL??? rpiswu2() 7FF697603590 000000056
al()+1185 035A89440 000000002
kxtexe()+14 CALL??? kxtExecuteTriggerRe 7FF67B47F480 000000000
al() 7FF600000004 000000000
updexe()+1279 CALL??? kxtexe() 000000001 0000001F4 000000001
00A2BE6F3
opiexe()+19564 CALL??? updexe() 0322B7370 7FF600000003
7FF600000102 000000000
kpoal8()+2482 CALL??? opiexe()+16981 000000049 000000003 035A8AEE8
000000001
opiodr()+1662 CALL??? kpoal8() 00000005E 00000001C 035A8E0D0
00B7FF224
ttcpip()+1325 CALL??? opiodr() 480000000000005E
49004D000000001C 035A8E0D0
4100200000000000
opitsk()+2040 CALL??? ttcpip() 012355D70 000000000 000000000
000000000
opiino()+1258 CALL??? opitsk() 000000000 000000000 000000000
035A8F9C8
opiodr()+1662 CALL??? opiino() 00000003C 000000004 035A8FA80
000000000
opidrv()+864 CALL??? opiodr() 00000003C 000000004 035A8FA80
6F5C3A6400000000
sou2o()+98 CALL??? opidrv()+150 00000003C 000000004 035A8FA80
000000000
opimai_real()+158 CALL??? sou2o() 1D7BCEC89DB66C0
1D7F2D502B87255 000000002
009F3593F
opimai()+191 CALL??? opimai_real() 000000000 000000000 000000000
000000000
OracleThreadStart() CALL??? opimai() 000000000 000000002 0085DFE20
+724 000000F60
00007FFF6EF97034 CALL??? OracleThreadStart() 0324BFEE8 000000000 000000000
000000000
00007FFF70242651 CALL??? 00007FFF6EF97020 000000000 000000000 000000000
000000000
Доступа на Metalink нет...
Помогите советом, пожалуйста
