Ora Masalah

 DECLARE @ID VARCHAR(50) = ID , @Name varchar(500) = NULL, @Title VARCHAR(20) = NULL BEGIN WAY: SELECT   @Name = X1.SuperiorName, @Title = (select JobLvlGrpName  FROM TBL_HRIS where empid = X1.SuperiorId)    FROM TBL_HRIS X1 WHERE EmpId = @ID SET @ID = (SELECT SuperiorId FROM TBL_HRIS WHERE EmpId = @ID) IF (@Title <> 'Manager') GOTO WAY; select @Name EMPID, @Title TITLE END

 create or replace view  PERIOD_MON_YYYY as WITH t (i, f)      AS (SELECT add_months(sysdate, -12), add_months(sysdate, 12) FROM DUAL          UNION ALL          SELECT CAST (ADD_MONTHS (TRUNC (i, 'mm'), 1) AS DATE) init, f            FROM t           WHERE ADD_MONTHS (TRUNC (i, 'mm'), 1) <= f) SELECT TO_CHAR (i, 'MON-YYYY') PERIODE   FROM t   order by to_date(TO_CHAR (i, 'MON-YYYY'), 'MON-YYYY');

 --EDIT  SELECT * FROM  XDO_DS_DEFINITIONS_B WHERE DATA_SOURCE_CODE in( 'XX_CSTACREP' , 'CSTACREP') ; --EDIT SELECT * FROM XDO_DS_DEFINITIONS_TL WHERE DATA_SOURCE_CODE in( 'XX_CSTACREP' , 'CSTACREP') ; --EDIT SELECT * FROM  XDO_TEMPLATES_B WHERE TEMPLATE_CODE in( 'XX_CSTACREP' , 'CSTACREP')   ;       --EDIT SELECT * FROM XDO_TEMPLATES_TL WHERE TEMPLATE_CODE in( 'XX_CSTACREP' , 'CSTACREP') ; --EDIT SELECT * FROM XDO_LOBS WHERE LOB_CODE in( 'XX_CSTACREP' , 'CSTACREP') ;

1. SELECT file_data, file_name            INTO l_blob_data, l_filename            FROM APPS.fnd_lobs           WHERE file_id = p_file_id;    2. Declare l_position number = 1;  Looping While : WHILE (l_position <= l_blob_len)     l_raw_chunk    :=   DBMS_LOB.SUBSTR (l_blob_data, c_chunk_len, l_position);     l_char         :=   CHR (hex_to_decimal (RAWTOHEX (l_raw_chunk)));     l_line          :=    l_line || l_char;     l_position   := l_position + c_chunk_len; IF l_char = CHR (10)             THEN                IF l_loop > 1                THEN                 --> header di text file...

  SRW.MESSAGE (msg_number NUMBER, msg_text CHAR)

Fungi ini berfungsi untuk menggunakan nilai dari parameter sebelumnya. Pada parameter sebelumnya harus berupa VALUE SET :$FLEX$.Value_Set_Name