Re: PL/SQL External Procedure

Update to this problem....
(Oracle 8 - NT4)
I found out that since the dll had to be on the server side to call, I forgot to
add the ODBC driver for the connection. With this done I no longer get the lost connection error but it now hangs. I need to bring the server down in order for it to release the dll.
Once again, if anybody has any advice -

Thanks in advance.. ( still dazed )

John Alden wrote in message <6uc3dc$cic$1_at_linux2.inet.maherterminals.com>...
>I'm new to pl/sql so I could use some advice to the following problem:
>
>I've created an external procedure to be accessed from an api.
>I've enabled the listener, placed the dll on the server,
> created the library pointing to the dll and finally the pl/sql function
> within the package.
>The package calls a C function that in turn calls a C++ function.
>The call to the C++ function works fine in that it passes and returns
> arguments ok, its just that when I try to create a (MFC) ODBC database
> connection I get the following error ( when testing from Oracle Sql
>Worksheet ):
>
> ORA-28576: lost RPC connection to external procedure agent
>
>Any help would be appreciated !
>
>Thanks very much in advance,
>John Alden ( dazed and confused )
>
>
Received on Thu Sep 24 1998 - 10:22:42 CDT