DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: UTL_FILE.GET_LINE

  1. #1
    Join Date
    Dec 2000
    Posts
    3

    Angry

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


  2. #2
    Join Date
    Dec 2000
    Posts
    9
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width