• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can we explicitly call triggers?

 
Gaurav Kshatriya
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I want to know whether can we explicitly call a trigger ??

 
Scott Selikoff
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why not put your trigger code in a stored procedure and explicitly call that? Then, just have your trigger call the stored procedure.
 
Gaurav Kshatriya
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Scott

Thanks for the useful information. Can you please throw some more light on this. It will be highly appreciable.
 
Darryl Burke
Bartender
Posts: 5148
11
Java Netbeans IDE Opera
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't really see that anything could be more explicit than Scott's response.

  • You can call a stored procedure
  • The trigger can call a stored procedure


  • Still don't get it?
     
    Wendy Gibbons
    Bartender
    Posts: 1111
    Eclipse IDE Oracle VI Editor
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    isn't the point of a trigger in that it gets triggered by an event on the database, so why do you want to call it?
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic