Skip to main content

dbms_job.submit with OUT Parameters

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;


Step 3: Check whether the JOB is submitted.

SELECT * FROM user_jobs WHERE job_id = <<l_job_id>>;

That's it. EnjoYing!!!...

Comments

Popular posts from this blog

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1:  Go to page footer and copy and paste the below script. Page |  <?fo:page-number?>  of  <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> :   This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> :  This is the syntax, which is used to represent the total number of pages. Step 2:  Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Oracle Application Express Views (APEX)

Application Express Views Search SELECT * FROM apex_dictionary WHERE column_id = 0; View Comment Parent View APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS ...

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT  *     FROM   ( SELECT  emp . empno ,                emp . ename ,                emp . JOB ,                dept . dname department ,                dept . loc  LOCATION ,                mgr . ename  ...