Very Specific error from Tool

[gopi]

The following scenario we have done 1000s of times and now the tool is having a problem with a very specific scenario. Oracle 9.2.0.1 solaris 8:
This scenario was tried on 5 machines and all with the same results. This just started!
1. we logon to a specific schema (let's call it prod1 schema).
2. We bring up the code from dB into program window.
3. we hit F8 to compile and we are disconnected from session and a trace file is created. No specific error except for the Ora disconnect message.
4. We can compile from schema prod1 using SQL*Plus
5. We can compile from a PL/SQL Developer using the command window. we copy-n-paste the code into the command window and then / in schema prod1. This works!
6. We can logon to schema SYSTEM and use the program window and compile the procedure across to schema Prod1.

The bug is with number 1 through 3 only ! This just started. The trace file was sent to Oracle via a tar. Please advise.
Thanks,
Frank

 

[gulhaugen]

Try going to Tools->preferences->Debugging and uncheck "Add debug information when compiling".

The issue is discussed in another topic I think.

 

[gopi]

The problem with compiling and the udump trace just disapeared ! We can compile again. But I can't rest...what happened?

could you give me advice on searching this forum so I can maybe find the thread where this was talked about?

Oracle support also asked:
Do you have any debugging running on the developer? example:
CDC or "Change Data Capture" feature of Oracle rdbms.
- We do not.

I have not unchecked "Add debug information when compiling" because we are okay again.

But still troubled here.

Thanks for any additional thoughts,
Frank

 

[gulhaugen]

Here's the link:
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=000476#000003

Could you also check the alert trace? Hopefully you also have the read_pipe error, and this can be tracked down.