Need opinion on calling web service from trigger.
I was wondering what's the best way to call a web service from a trigger.
I was thinking of creating a procedure that would call the web service and check the returning result of the call. then creating a trigger on a table which would use dbms_scheduler.create_job to create a job that would call the procedure.
currently the trigger calls the web service directly, but to now to update 1 row it days 1-2 seconds because i have to wait for the web service to return.
Is there anything wrong with creating a job every time the trigger is fired? is what i plan to do going to cause any problems?