My Oracle Support Banner

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

Last updated on MARCH 10, 2019

Applies to:

Oracle Database - 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

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

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\user>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 "USER1.OACREATE", line 1
ORA-06512: at "USER1.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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.