NO CONNECTION TO ORACLE during compilation

[Wojtek]

I've notice, that sometimes during compilation of pckg there occur message:
"ORA-03114 - no connection to Oracle"
In v$session there is :
BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' AND SYS.dbms_cdc_publish.active > 0
THEN
SYS.dbms_cdc_publish.change_table_trigger (dictionary_obj_owner,
dictionary_obj_name,
'LOCK'
);
END IF;
END;

for a while, for compiled session, and then session is breaking. Has anybody the same situation ?

conf: w2k+sp3 oracle 9.2.0.5

regs

 

[Wojtek]

I forgot to add, that it doesn't metter if debug information is added or not. PLSQLDEV Version 6.0.3.893 (MBCS).

 

[Marco Kalter]

Seems like a DDL trigger to me. Do you have any DDL triggers? Does it help if you disable them? Do you get the same error for the same compilation in SQL*Plus?

 

[Wojtek]

Hi,
no there is no DDL triggers. When I compile under SQL*Plus/SQL Navigator/TOAD - everything's ok.
Looks like some settings in the application.
It occure almost everytime when I try to compile procedure/package from program window. Compilation from browser - right click - recompile is ok.
But one more thing. It occure only on my production machine, on dev machine everything is ok. Parameters of this two dbs differs only on memory parameters.
In plsqldev.log file there is no entries about this error.
Is there any way to trace this situation?

regards

 

[Marco Kalter]

What happens if you try the same compilation in the Command Window?

Note that the SQL text you included above is clearly from a DDL trigger. Unless you quoted the wrong SQL code, you do have a DDL trigger that leads to this error.