Skip to content

Instantly share code, notes, and snippets.

@jon-dixon
Last active December 26, 2022 18:05
Embed
What would you like to do?
ARCS Job Status PL/SQL Block Example
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment