Skip to content

Instantly share code, notes, and snippets.

Last active December 26, 2022 18:05
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
What would you like to do?
ARCS Job Status PL/SQL Block Example
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);
-- Call the helper procedure to Start the Import Job.
(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||']');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment