ORDCOM Fails (ORA-28578) when Secure External Password Store (SEPS) is Configured (Doc ID 1072712.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.1.0 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

While using Oracles ORDCOM infrastructure installed from %ORACLE_HOME%\com\comwrap.sql on  database to interact with a COM object. The COM object doesn't do anything with the database, it's just called from the database.
You must have other program outside of the database that can test the COM object and that continues to work correctly.
As soon as you comment out the line (SQLNET.WALLET_OVERRIDE = TRUE)  in sqlnet.ora it all works correctly, but of course you can no longer use the SEPS.

C:\Documents and Settings\languser>sqlplus /@ora10204

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 9 09:11:53 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set serveroutput on
SQL> declare
2 applicationToken BINARY_INTEGER := -1;
3 hresult BINARY_INTEGER := 0;
4 v_result binary_integer := 0;
5 BEGIN
6 hresult := ORDCOM.CreateObject('myspace.mycsharpclass',0,'',applicationToke
n);
7 ordcom.initarg();
8 ORDCOM.SetArg(5,'pI4');
9 hresult := ORDCOM.Invoke(applicationToken, 'doubleit',1, v_result);
10 dbms_output.put_line('5 doubled is ' || v_result);
11 hresult:=ORDCOM.DestroyObject(applicationToken);
12 applicationToken := -1;
13 END;
14 /
declare
*
ERROR at line 1:
ORA-28578: protocol error during callback from an external procedure
ORA-06512: at "SCOTT.OACREATE", line 1
ORA-06512: at "SCOTT.ORDCOM", line 274
ORA-06512: at line 6

Changes

You have configured Secure External Password Store (SEPS)  where username/password are stored in the wallet and you connect with just /@<tns connect string>

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