ORA-28578 During Execution Of .Net Stored Procedure By Non-Owner

(Doc ID 464328.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version: 10.2.0.2.20 and later   [Release: and later ]
Oracle Database Extensions for .NET - Version: 10.2.0.1.0 to 10.2.0.3.0]
Microsoft Windows (32-bit)

Symptoms

Trying to run an Oracle .Net Stored Procedure from a non-owning user results in the following error:

ORA-28578: protocol error during callback from an external procedure
ORA-06512: at "SYS.DBMS_CLR", line 243
ORA-06512: at "BL_PB.ADD99", line 7
ORA-06512: at line 1
The same .Net Stored Procedure executes correctly when run using the owning user. Also, both users can run an external procedure dll correctly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms