Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Execute a Trigger?
Hi,
Rewrite your trigger to call a stored procedure. Then your c++ routine
can call the stored proc.
Cindy
"laleonard_SpamBanana_AT_mindspring.com" wrote:
> A novice question: I have a "After Update" trigger on a column of a
> table. I am writing a C++ program, and I want to make this trigger
> fire.
>
> I know that I can make the trigger fire by simply writing to that
> column in that table, but is a more direct approach? I'm looking for
> something like:
>
> ::SQLExecDirect("EXECUTE TRIGGER MyTrigger");
>
> Thanks.
>
> ==============================================
> Definitive Solutions, Inc - Makers of AprCalc,
> the Premier Shareware Mortgage Calculator for
> Windows. www.DefinitiveSolutions.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 14:00:53 CDT