Sv: Pro* C questions ???

From: J. Wegener NOSPAM <xjw_at_xdde.xdk>
Date: Thu, 1 Jul 1999 13:50:39 +0200
Message-ID: <7lfkjv$kes$1@news101.telia.com>

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.

Cheers,
Johan
--
Johan Wegener
Dansk Data Elektronik A/S
Reply to: xjw_at_xdde.xdk
NOSPAM: Delete xxx from my email address Received on Thu Jul 01 1999 - 06:50:39 CDT