Comipile causes disconnect and trace file

[rmaggio]

We've been recently getting errors when our developers compile procedures. Selecting a procedure and right clicking over to select COMPILE causes an ORA-01401 Hosdef does not exist error, followed by a trace file in the db which includes the following
** SESSION ID

137.907) 2003-04-07 10:41:18.684
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8, PC: [0x16a8928, ptmak()+440]
*** 2003-04-07 10:41:18.727
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ptmak()+440] [SIGSEGV] [Address not mapped to object] [0x8] [] []
Current SQL statement for this session:
BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' THEN
sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
END IF;
END;
----- Call Stack Trace -----

Flushing the shared pool seems to clear it up. We are unable to duplicate it using Oracle SQLPLUS to compile.

 

[Marco Kalter]

In situations where SQL*Plus compiles correctly and PL/SQL Developer causes problems, you are most likely running into a restriction with the Oracle debugger.

See this topic for a solution.

------------------
Marco Kalter
Allround Automations