Re: How to call a C program from a PL/SQL package

I am not sure about 7.3, but starting in 8.0.3 it is possible to add a library object that consists of a C library. Whether it works or not dependes on whether the OS supports DLL style libraries.

Oracle Tech Support had a white paper about a year ago on how to set it up. I haven't gotten it to work, but I am not sure if the problem was mine, my OS (windows) or Oracles and haven't had time to research it, but it is supposed to be doable.

In article <362C5451.78C5_at_sia.ucl.ac.be>,   lelangue_at_sia.ucl.ac.be wrote:
> Hello all,
>
> I work with PL/SQL 2.3, Oracle 7.3
>
> I generate html pages with a PL/SQL package.
> For the intranet part, I have to identify the user.
> Since few days, we have an encrypted password in the Oracle DB for each
> user. The passwords are generated with a C program.
> We have other C procedure that can check if the password encoded is the
> right password for the user.
>
> Is this possible call the C procedure from my package and to obtain
> something
> like following ?
>
> package
> ...
> ...
> flag := check_pass(cst,pass,user); -- check_pass is a C program.
> if (flag != 1)
> redirect to "incorrect name or pass";
> end if;
> ...
> ...
> end package;
>
> I have read in the PL/SQL User's guide & réf [chap 9] about how to call
> PL/SQL from a C program; but nothing about how to call a C program from
> a PL/SQL package.
>
> Any tips ?
>
> TIA
> Bertrand Lelangue, SIA, Catholic University of Louvain, Belgium.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 15:53:25 CDT