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
jiss
Messages: 1
Registered: December 2006
Junior Member
Hi,

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 ?

Thx

Jiss
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
begin
 my_proc( :new.empno);
end;
/


http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:952229840241

[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: Wed Dec 07 09:06:12 CST 2016

Total time taken to generate the page: 0.09754 seconds