Re: Sv: Pro* C questions ???

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Thu, 01 Jul 1999 08:00:33 -0400
Message-ID: <377B5861.49C068CB@Unforgettable.com>

Is ORA_FFI new to Oracle 8? It isn't available in 7.3 that I know of.

"J. Wegener NOSPAM" wrote:

> Chow Hoi Ka, Eric <d951686_at_sftw.umac.mo> skrev i en
> nyhedsmeddelelse:377B509C.3756121B_at_sftw.umac.mo...
> > 1) How to delete a record in Pro* C ?
>
> Using Pro*C, you can embed any SQL statement including DELETE. A trivial
> example:
> EXEC SQL DELETE FROM EMP WHERE ENAME = 'SCOTT';
>
> > 2) How to call a Pro* C program in PL/SQL ??????
> The best way, IMO, is to place your Pro*C logic in a DLL/shared library and
> use the ORA_FFI package to access it.
> In other words, declare an external PL/SQL procedure that refers to your
> DLL and call this external procedure from PL/SQL.
Received on Thu Jul 01 1999 - 07:00:33 CDT