-
For loop is not working inside program
Hi, I would like to get below output If the input is 12-Aug-2016 the output should be 16-Aug-2016. But I'm getting 15-Aug-2016 a soutput which is offshore holiday. so created for loop it checks v_dt = holiday_date if it matches then it will increment by 1 v_dt:=v_dt+1 else v_dt but this loop is not...
-
How to insert data from one to another PL/SQL using procedure
I am trying to insert the data to PO_HEADERS table from po_header_temp. There are 3 columns (PO_ID_REQ int,SALES_ORDER_NUM varchar2(400),QUOTE# varchar2(400)). I have tried the following procedure. CREATE or REPLACE PROCEDURE PO_SAP_DATA ( PO_ID_REQ int, SALES_ORDER_NUM varchar2(400), QUOTE#...