Re: Can I do external procedure calls with Personal Oracle 8.1.7 - it doesn't work

"brian" <brian.pacitti_at_btinternet.com> wrote in message news:<ag2ih6$h0t$1_at_paris.btinternet.com>...
> Hi there,
>
> I am trying to run an external DLL from within PL/SQL and am getting an
> ora-28575 error. I am running Personal Oracle 8.1.7 on Windows 98.
>
> I have read the copious number of posts on the subject and my tnsnames.ora,
> listener.ora and sqlnet.ora appear to be set up correctly. In any case this
> is a new installation of Personal Oracle 8.1.7 and the .ora configurations
> for external procedure calls is done automatically on installation. Also I
> can run the extproc.exe from MS-DOS.
>
> I am testing this by trying to call a windows function from one of the
> standard windows DLLs but am getting an ora-28575. This is what I am doing:
>
>
> CREATE OR REPLACE LIBRARY dlltest_library AS
> 'c:\windows\system\advapi32.dll' ;
> /
> CREATE OR REPLACE function dlltest_function (V IN OUT VARCHAR2, W IN OUT
> long) return boolean AS
> external name "GetUserNameA" library dlltest_library;
> /
> declare
> lb_rtn boolean;
> ls_username varchar2(30);
> ll_length long;
> BEGIN
> ll_length := 255;
> ls_username := ' ';
> lb_rtn := dlltest_function (ls_username, ll_length );
> dbms_output.put_line('username = '||ls_username);
> END;
> /
>
> Is there any other configuration I must do (parameter in the init.ora for
> example) to get this to work ?
>
> I never had much hair before I started this task anyway !!
>
> Any help would be much appreciated although I guess I am asking the same
> question as a number of other posts.
>
> Thanks
> Brian

There could be more then one reason for getting 28575. Check DocID 70638.1 at Oracle's Metalink for detailed resolution. http://metalink.oracle.com

HTH
//Rauf Sarwar Received on Thu Jul 04 2002 - 20:38:00 CDT