트리거에서.. 자바실행 가능한가요?

GAScripter

Need to call a Java Object / Servlet from a Trigger

Hi could anyone please help me on this issue .

We are using Oracle 10g as our DataBase .

Is it possile to write a Trigger in such a way that whenever there is a chnage in Database (insert/update) We need to call a Servlet/Or any Java Program

Any link will be a great help .

Thanks in advance .

Save India From Corruption - Anna Hazare

Here you find java stored trigger sample:
http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijsp.html

I am not sure if calling servlet from the triger at each insert/update is a good idea, that could cause performance problems.

Thanks for the replies when i tried with this syntax :

1

2

3

4

5

6

CREATE TRIGGER Lad
        AFTER INSERT ON dept
        BEGIN
     
UTL_HTTP.REQUEST('http://localhost:7001/Test/servlet/Hai')  
        END  Lad;

// I had created a servlet and placed it in my server .

At first

When i created this trigger in Oracle it displayed as
Warning: Trigger created with compilation errors.

and when i inserted some sample values in the dept table in database .

ORA-04098: trigger 'SCOTT.LAD' is invalid and failed re-validation

Any ideas .

Save India From Corruption - Anna Hazare.

< Prev ORACLE DB 기동 및 Down

[ORACLE] 트리거 사용 예제 Next >

♥