We have an Oracle stage with a custom insert SQL. To fulfill some requirements, we are modifying the insert to include a function so that my insert will look something like :
Code: Select all
INSERT INTO XYZ_EDI_852_DLY_FACT
(EDI_SNDR_KEY,......,BU_CODE,OPER_WK_END_DT) VALUES (:1,...., GET_BU_CODE_X(:11,:2),GET_WK_CLS_DT(:2) );
Help appreciated.