515: -- End (bug 2905278)
516:
517:
518: -- now make a network call
519: v_response := utl_http.request(v_url);
520:
521: -- now parse the response to determine status based on agent.
522: if agent = PLSQL_AGNT then
523: declare
584: end if;
585:
586: return v_status;
587: EXCEPTION
588: when utl_http.init_failed then
589: --dbms_output.put_line('INIT_FAILED');
590: return STATUS_UNKNOWN;
591: when utl_http.request_failed then
592: --dbms_output.put_line('REQUEST_FAILED');
587: EXCEPTION
588: when utl_http.init_failed then
589: --dbms_output.put_line('INIT_FAILED');
590: return STATUS_UNKNOWN;
591: when utl_http.request_failed then
592: --dbms_output.put_line('REQUEST_FAILED');
593: return STATUS_ERROR;
594: when others then
595: return STATUS_UNKNOWN;