ORDCOM Fails (ORA-28578) when Secure External Password Store (SEPS) is Configured
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.2Information 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 6Changes
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