| calling java from database trigger [message #54662] |
Tue, 26 November 2002 07:13  |
rena
Messages: 8
Registered: November 2002
|
Junior Member |
|
|
I want to create a trigger that when an insertion is made in an Oracle database the same insertion is made to a remote MS Access database.
I think i can use rmijdbc...,that is for the connection to Access database.
I also found how to call java from database triggers
So, (as mentioned in the link www.znow .com/sales/oracle/java.816/a81358/04_call2.htm
Example1
but when i create the trigger with the statement:
CREATE OR REPLACE TRIGGER sal_trig AFTER INSERT ON emp CALL log_sal(:new.empno, :old.sal, :new.sal);
/
I am getting the error:
ORA-00911.
is there any error in the syntax?
How i can i solve it?
an it would works if in the corresponding function in the java file i specify an insert statement to a table of the Access database.i.e a remote to Oracle database.
Please answer beacuse i need it urgently
Advance thanks
maria
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
