Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to Execute a Trigger?

Re: How to Execute a Trigger?

From: C. <c_ferguson_at_rationalconcepts.com>
Date: Tue, 29 Jun 1999 12:00:53 -0700
Message-ID: <377917E4.D5E2B25F@rationalconcepts.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US