ARCS Job Status PL/SQL Block Example

arcs_job_status_example.sql

DECLARE
  lc_arcs_job_status_url CONSTANT VARCHAR2(100) := '<BaseURL>/arm/rest/v1/jobs/100000003540031';
  l_job_complete         VARCHAR2(1);
  l_job_status_code      NUMBER;
  l_jobs_status_details  VARCHAR2(32000);
BEGIN

  -- Call the helper procedure to Start the Import Job.
  arcs_utl_pk.job_status
   (p_job_status_url     => lc_arcs_job_status_url,
    x_job_complete       => l_job_complete,
    x_job_status_code    => l_job_status_code,
    x_job_status_details => l_jobs_status_details);

  dbms_output.put_line('Job Complete ['||l_job_complete||'], Job Status Code ['||l_job_status_code||'], Details ['||l_jobs_status_details||']');

END;