PL/SQL (MOSC)

MOSC Banner

Oracle External Proc / ORDCOM argument value not recognized

edited Jun 22, 2015 4:47PM in PL/SQL (MOSC) 2 commentsAnswered

I have a COM Dll with the following interface

HRESULT CreateEvent(

                [in, out] long* timeout,

                [in, out] BSTR* area,

                [in, out] BSTR* FieldValues,

                [in, out] BSTR* EventDescription,

                [in, out] BSTR* ErrMsg,

                [in, out] long* ErrMsgSize,

                [out, retval] short* );

I use it from a VB6 application in the same machine and it works properly.

When I try to use it in PL/SQL with ORDCOM everything works correctly except the arguments are not recognized at the destiny process.

For instance if I set the area as

v_area VARCHAR2(2) := 'US';

...

ORDCOM.InitArg();

ORDCOM.SetArg(v_area,'pBSTR')

...

hresult := ORDCOM.invoke(...

The invoke method works and returns 0, but the value v_area is not received as 'US' at the other end.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center