Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to call a C program from a PL/SQL package

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

From: B. Lelangue <lelangue_at_sia.ucl.ac.be>
Date: Tue, 20 Oct 1998 11:13:53 +0200
Message-ID: <362C5451.78C5@sia.ucl.ac.be>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US