'how to make oracle UTL_HTTP.request asynchronous?
I have a job that runs periodically , and I am not interested in the response ??
is there anyway to make the calling convention , request without waiting for the response ??
Regards,
Solution 1:[1]
I wrote the API request as a procedure and called the PL/SQL output in the DBMS_JOB method.
L_REQUEST:=' DECLARE
BEGIN
SCOTT.PROCEDURE_SENDER ('''|| ITEMS || ''',1);
COMMIT;
END;';
DBMS_OUTPUT.PUT_LINE (L_REQUEST);
DBMS_JOB.SUBMIT (L_JOB, L_REQUEST);
DBMS_OUTPUT.PUT_LINE (L_JOB);
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Amir Hassan |