Home » SQL & PL/SQL » SQL & PL/SQL » Trigger calls Java Class
Trigger calls Java Class [message #207446] Tue, 05 December 2006 10:58 Go to next message
Messages: 1
Registered: December 2006
Junior Member

I'm an Oracle beginner, and I need to perform the following program :
Based on a row creation on a specific table, I want to set-up a trigger that calls a Java class on another server with the row ID previously created as a parameter.

Is that possible on 10g ?


Re: Trigger calls Java Class [message #207461 is a reply to message #207446] Tue, 05 December 2006 11:59 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Try something like this...

create or replace trigger emp_ai --(after insert)
after insert on emp
for each row
 my_proc( :new.empno);


[Updated on: Tue, 05 December 2006 12:00]

Report message to a moderator

Previous Topic: run monthly script automatically
Next Topic: Case insensitive query (merged)
Goto Forum:

Current Time: Tue Oct 25 02:14:58 CDT 2016

Total time taken to generate the page: 0.16530 seconds