Oracle: how to execute insert trigger without delaying insert response?

Question

The trigger below delays my insert response. How can I prevent this?

create or replace
TRIGGER GETHTTPONINSERT
BEFORE INSERT ON TABLENAME
FOR EACH ROW 
Declare
  --   
BEGIN
  -- The inserted data is transfered via HTTP to a remote location
END;

EDIT People tell me to do batch jobs, but I'd rather have the data sooner than have 100% consistency. The advantage of a trigger is that this happens as soon as the data arrives, but I cannot afford to delay the response of the insert.

Answer 1

There is an ideal solution for this exact situation called database change notification.

You can think of it almost exactly as an asynchronous trigger.

DBMS_Change_Notification, , , . DML DDL, Oracle ( 10 ). sproc , rowid ... , , HTTP. . 10gR2

Answer 2

, dbms_job, () http. dbms_job , , .

. http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7267435205059 - , .

Answer 3

, , , , , X . , , .

Answer 4

Oracle? http . , ? hhtp send , .

Answer 5

, , .... Else, , , TRIGGER INSERT.

Or maybe you could give us more detailed information about what you need exactly?