Re: Pro* C questions ???

A copy of this was sent to "Chow Hoi Ka, Eric" <d951686_at_sftw.umac.mo> (if that email address didn't require changing) On Thu, 01 Jul 1999 19:27:25 +0800, you wrote:

>Hello,
>
>1) How to delete a record in Pro* C ?
>

  exec sql delete from T where ...;

>2) How to call a Pro* C program in PL/SQL ??????
>

you don't call pro*c from plsql -- you call plsql from pro*c.

In Oracle8i, release 8.1 you can write external procedures in Pro*c. This lets you write a stored procedure in Pro*c which is a way of allowing plsql to call pro*c but in general, pro*c calls plsql.

>
>Best regards,
>Eric

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 01 1999 - 07:20:07 CDT