Database

Database

DBMS_JOB – Oracle

Submitting DBMS JOB with Store Procedure having both IN and OUT Parameter. 1) Create Procedure create or replace PROCEDURE SP_JOB_TEST_PR ( INPUTDATA IN NUMBER ,OUTPUTDATA OUT VARCHAR2 ) AS BEGIN — Do what ever you want here DBMS_OUTPUT.PUT_LINE (‘Procedure Executed’); END SP_JOB_TEST_PR; 2) Submit the Job BEGIN DECLARE v_JobNum NUMBER; BEGIN DBMS_JOB.SUBMIT(v_JobNum,’ declare INPUTDATA NUMBER; […]

Read More