Re: how to execute a C program via trigger ?

On Mon, 4 Dec 2000 18:20:29 -0800 (PST), S.F. Lee said:

> Thank for your hint, but I have some questions :
>  
>    1. Do I have to compile the C program into a shared
>  object (*.so)? 

yes

>    2. Do I have to use SPI (SPI is too complicate to
>  me)? 
>  
>    My request is very simple. I have a program
>  (my_c_program) 
>    that I can execute it under shell by typing
>  (my_c_program).
>    Basically my_c_program is not a function.
>  


im not sure anyone?


>    I want to fire a trigger after I update the field
>  (x) in table foo, and the trigger can run the
>  my_c_program. Is there an easy way to execute a
>  PROCESS
>  via trigger?
>  
>     regards,    S.F. Lee
>  


id say dont use C!! use pl/sql 

but if your trying to learn the prog of c functions
youll have to get help elsewhere unfortunatley

im not even newbie status on c!