-
I've coded as follows:
UTL_FILE.GET_LINE(FPINFILE IN UTL_FILE.FILE_TYPE,
V_LINE OUT VARCHAR2);
and get this error:
PLS-00103: Encountered the symbol "OUT" when expecting one of the following:
. ( ) , * @ % & | = - + < / > in mod not range rem => ..
an exponent (**) <> or != or ~= >= <= <> and or like between
is null is not ||
The symbol ". was inserted before "OUT" to continue.
ANYONE OUT THERE with experience in using this package??
-
Hi
You can not use the GET_LINE as a parameter I think. First you should declare the FPINFILE then U can use that in the GET_LINE;
ex:
PROCEDURE TEST(line OUT VARCHAR2)
IS
FPINFILE UTL_FILE.FILE_TYPE;
line_buf VARCHAR2(240);
BEGIN
UTL_FILE.FOPEN( file_path, file_name, open_mode);
UTL_FILE.GET_LINE(FPINFILE, v_line);
line := v_line;
---
---
---
I think this may help you.
Surya
