Ora Masalah

 --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...