Re: Calling 'C' routine from PL/SQL
Date: 1996/11/16
Message-ID: <328E2D3F.485C_at_pl.lu>#1/1
Rakesh Patel wrote:
>
> Hi,
>
> I know the normal way to call a C routine from PL/SQL is to use
> dbms_pipes or kick start by means of an alert, but has anyone identified
> a method of calling it directly from PL/SQL, ie re-linking Oracle
> executable with the C routine.
> Database version 7.3.
>
> Thanks in advance
>
> Rakesh
Good evening,
If you find any solution you can copy the article.
av153_at_tibco.com
flange_at_pt.lu
Other Idea to do it.
It's ONLY IDEA.
- Call an other database with transparent gateway which can do it, like DB2 can call CICS ( I thinks so ).
- Create store procedure on a remote database check the what is send by sqlnet on the network. trace_level=16 and mimick it by a C program.
- Ask Oracle how to create a trnasparent gateway ( Remote Procedure Part ) and call your program.
The advantages of this solution will be the two fast commit will be available and not a trigger sending information by DBMS_PIPE. If you rollback the work the information will never be rollback in the DBMS_PIPE. Regards Francois. Received on Sat Nov 16 1996 - 00:00:00 CET