Database Connection Dropped when trying to compile Package

[LaurenM]

Hello All,

I am currently adding a function to a package that I created. Whenever I try to compile the package, PL/SQL gives me a ORA-03114: not connected to ORACLE error. The first time this happened I thought that the connection had timed out. So, I logged in to the database, and compiled the package, and same error. I logged in again and tried running some SQL, no problem connection is there, go to the package, and tried compiling, and again ORA-03114. Does any one have any hints or know of settings that I need to look at?

Thanks,
Lauren

 

[Roeland]

2 options I think of:
1) Try to set debugging of.
=> Tools>Preferences>Debugger
And then you have the choice:
- uncheck "Add Debug info when compiling"
- Add your current DB connection in "never add debug info for collection"

2) Look at the version of your Oracle Client. Is it the same as that of the server? Could the client or the server handle the code of that method?

Just my 2 cents,

Kind regards,

Roeland

 

[LaurenM]

Hi Roeland,

The first step worked. Thanks for the pointer on this one.

Lauren