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
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.
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 |