Home » SQL & PL/SQL » SQL & PL/SQL » triggers
triggers [message #197516] Wed, 11 October 2006 10:24 Go to next message
Messages: 4
Registered: October 2006
Junior Member
can database triggers also be a C or Java procedure other than being a pl/sql block ? this has been stated as true by one of the websites providing dumps for izo-147 exams. i am in doubt , please confirm correctness, calling a C or Java procedure is different from the trigger itself being such a procedure. thanks in anticipation.
Re: triggers [message #197529 is a reply to message #197516] Wed, 11 October 2006 11:40 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
The trigger is always PL/SQL and PL/SQL can call C or Java. Even if you have a stored proc/function which calls c/Java, you can call that proc/function from the trigger. Can a developer write a C or Java trigger without any PL/SQL wrapper - not as far as I know.

[Updated on: Wed, 11 October 2006 11:43]

Report message to a moderator

Previous Topic: dblink to sql server returns double recordset
Next Topic: Foreign Key Constraint
Goto Forum:

Current Time: Thu Jul 27 12:26:57 CDT 2017

Total time taken to generate the page: 0.07931 seconds