Re: C/C++ External Procedure

FWIW when I have received this message, it's because I've killed the extproc.exe program which is the bridge between PL/SQL and the Win32 dll. Pointer (e.g. *char) handling between PL/SQL & Win32 is complex. I have yet to make it work well.

Good luck,
-Porter Hart

> Greg Vitetzakis wrote:
>
> I'm using Oracle 8i, with VC++6 to try to prototype the following.
>
> 1- I'm able to Create a Win32 DLL project that can contain Functions
> that receive numeric values, and return a numeric value. Once its
> created, I create a library in Oracle
> and a function that references the library, and everything works great
> and fast.
>
> 2- Create the same type of function as above that receive char or
> string variables and returns a string or char. Creating the DLL is
> fine, the Library and function is fine. When I
> call it, I keep getting the following errors.
>
>
> select cc('A','B') from dual
> *
> ERROR at line 1:
> ORA-28576: lost RPC connection to external procedure agent
>
> Has anyone created such functions or procedures in C/++ that work and
> could explain to me how and why? Ultimetly i would like to return a
> Cursor.
>
> Thanks
>
>
> Greg Vitetzakis
> V.P. Professional Services
> OSTnet (Open Source Technologies Inc.)
> (514) 278-7678 x246
> www.ostnet.com
>
> [Image]
>
>
Received on Mon Feb 26 2001 - 00:44:03 CST