Problem with test window

[ScottMattes]

I have a long running Stored Procedure and every time it gets to the end I see

- the Commit/Rollback buttons become active

- then when I expect PLSD to be getting the DBMS_OUTPUT output I get 'end of file and communications channel' and 'not connected to oracle' and NO output

Is this a known problem (Oracle or PLSD) and is there a work around?

Thank you.

 

[Marco Kalter]

ORA-03113 usually means that the Oracle Server process for the current session has crashed. Can you check if a user trace dump file exist on the database server that corresponds to this ORA-03113 error? Usually you will see an ORA-00600 or ORA-07445 error here, with some error codes that may help us find the cause of the problem. If it does, can you send it to me?

 

[ScottMattes]

I'll go ask.

Right after acknowledging the 3113 I get the 'not connected to Oracle' msg.

 

[ScottMattes]

There was no dump created, sorry.

I did get the exact same two msgs, 3113 followed by not connected to Oracle, in a SQL Window and I am wondering if it is some sort of timeout problem. The SQL Window had the first 200 rows displayed in the result grid and I hadn't been back to that window in quite a while. When I saw that there were more rows I clicked the 'get them all' button and immediately got the two msgs.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[ScottMattes]

OK, I'll try that as I leave for home this afternoon. I won't be able to send before the 16th though, we are going for a sonogram Tues and I want to be there so my travel week doesn't start until Wed.