Triggers

• nagendra

  SSC Rookie

  Points: 26

  More actions

  October 18, 2001 at 5:48 pm

  #77798

  Let me keep it simple :

  I want to invoke a method , when ever there is a record added to the SQL server ..Is it possible.

  Method : This is a class file which in turn updates another database , say (oracle or LDAP)

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734564

  More actions

  October 18, 2001 at 6:24 pm

  #419127

  You have a few options.

  1. Trigger - Can run more SQL statements. However, the transaction does not complete until the statement comepletes. Be careful with this.

  2. Replicate the record

  3. Use some process that polls for new records and moves them (recommended).

  Steve Jones

  steve@dkranch.net