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

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. Received on Tue Oct 20 1998 - 04:13:53 CDT