Calling Windows Builtin Functions Using External Procedures Fails With ORA-28576
Last updated on JUNE 19, 2017
Applies to:PL/SQL - Version 184.108.40.206 and later
Microsoft Windows (32-bit)
Beginning with Oracle 9iR1 (9.0.1.X) RDBMS and higher on Windows Platform you may get an
if you try to call functions from a DLL by using EXTPROC.
The cause of the Problem is the definition of the calling convention of the library function. If the convention
is used (Compiler Option /Gd), the library function can be called without raising ORA-28576 - but if the convention
is used (Compiler Option /Gz), then the ORA-28576 is raised.
To overcome this limitation a sort of "intermediate dll" which will be called by EXTPROC and loads the target library and executes the desired function. For every function used in combination with EXTPROC and declared as __stdcall there has to be a counterpart in the "intermediate dll"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms