Oracle12c and PL/SQL Developer 10

[JoeyM]

Hi All,

I'm experiencing problems with Oracle12c and PL/SQL Developer Version 10.

I'm able to connect to the oracle 12c database fine. The problem I'm experiencing is when I attempt to perform a select from a table or view a store procedure/function.

The error message I get is:
ORA-12801: error signaled in parallel query server P000,......
ORA-00600: internal error code, arguments[kxspoac: EXL 1].....

Has anyone experienced this error before? Has anyone manage to successfully use PL/SQL Developer 10 with Oracle12c?

Thanks,
Joey

 

[Marco Kalter]

PL/SQL Developer works just fine on Oracle12c. The ORA-00600 error indicates an Oracle Server bug. You should therefore probably contact your Oracle support representative about this error or apply the latest patches to the Oracle12c Server.

 

[JoeyM]

Hi all,

I resolved this issue as follow:
1. I downloaded the Oracle12c 32bit instant client for windows
2. In PL/SQL developer 10, I went to Tools->Preferences->Oracle Connection and set the 'OCI Library' path to the Oracle12c instant client I downloaded.
3. I restarted PL/SQL Developer and all worked fine after that!!

Thanks,
Joey.

 

[Marco Kalter]

Great, thanks for your feedback.