Creating trigger => Connection dropped?!?

[Roeland]

Hi,

When I create a trigger with the wizard and I try to install it, my connection is dropped. This happen on an Oracle 9.2.0.1.0

The trigger is as simple as

create or replace trigger Table_Test_Tr
  before insert on Table_Test
  for each row
declare
  -- local variables here
begin
  Null;
end Table_Test_Tr;

When I copy/paste everything in an SQL window the trigger is created without a problem.

On a Oracle 10 I do the same but then without a problem.

Client version is 9.2 (OCI)
PL/SQL Dev version 7.0.3.1123

 

[Marco Kalter]

What exactly is the error message? Is there a user dump trace file on the database server?

 

[Roeland]

The error message is:

ORA-03114: Niet verbonden met ORACLE.

About that user dump trace file, I'll try to check and get it, but this is happening on a production oracle in another environment.

 

[Marco Kalter]

If a compilation causes such an error and works correctly in other windows, then I suspect a problem with the "debug information" mode. To verify this, go to Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option, and retry the compilation.

You can also explicitly exclude specific objects from debug information. On the same debugger tab page you can add a line with the name (or owner.name) of the program unit to the "NEVER add debug info for objects" list.

 

[Roeland]

It's working now. Thanks.

But I have enabled the "Add debug information when compiling" option again, and it keeps working?

Could it be that some breakpoints in a package are causing this? It keeps me puzzling??

 

[Marco Kalter]

The problem is not related to breakpoints, which are not persistent but only exist during a debug session. It's difficult to say why it works now though, but Oracle bugs can be unpredictable.