Step 1: Create a procedure with OUT parameters. (As per your requirement)
Procedure: xxpa_offers.create_invoice
OUT Parameters: x_return_status, x_return_message
Step 2: Lets look at the program execution as shown below,
SET serveroutput ON;
DECLARE
l_job_id INT;
BEGIN
dbms_job.submit( l_job_id,'DECLARE
x_return_status varchar2(2);
x_retrun_message varchar2(4000);
begin
xxpa_offers.create_invoice('||:p1_offer_run_id||',x_return_status,x_return_message); end;'
);
dbms_output.put_line (l_job_id ); -- Print the Job ID
dbms_output.put_line ('Status: '||x_return_status||' | Message: '||x_return_message);
END;
Procedure: xxpa_offers.create_invoice
OUT Parameters: x_return_status, x_return_message
Step 2: Lets look at the program execution as shown below,
SET serveroutput ON;
DECLARE
l_job_id INT;
BEGIN
dbms_job.submit( l_job_id,'DECLARE
x_return_status varchar2(2);
x_retrun_message varchar2(4000);
begin
xxpa_offers.create_invoice('||:p1_offer_run_id||',x_return_status,x_return_message); end;'
);
dbms_output.put_line (l_job_id ); -- Print the Job ID
dbms_output.put_line ('Status: '||x_return_status||' | Message: '||x_return_message);
END;
Step 3: Check whether the JOB is submitted.
SELECT * FROM user_jobs WHERE job_id = <<l_job_id>>;
That's it. EnjoYing!!!...
Comments
Post a Comment