Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL-SQL get_line, Help me

Re: PL-SQL get_line, Help me

From: Huberto Kusters <Huberto.Kusters_at_abp.nl>
Date: Thu, 24 Feb 2000 15:52:28 +0100
Message-ID: <893gjg$h5r13@abp.nl>


Hi,

The exception you receive is probably related to the = dbms_output.put_line command, which can only handle strings of 255 bytes = max.

Best regards,

Huberto
  Chevalier Christophe <Chevalier_at_e-med.ch> schreef in berichtnieuws = 38B3A2C7.F631EB3D_at_e-med.ch...
  Hello,
  I have a problem with a procedure PL-SQL. I manage to open a textual = file with method OPEN_FILE and GET_LINE, but if the file that I open = contains of the lines of more than ~400 car, I have execption.

  Also, here the code which I use to open my file.

  =

==========================
==========================
==========================
CREATE OR REPLACE procedure L_FILE ( F_NAME in VARCHAR2, F_TYPE IN VARCHAR2 )IS

   FILE_OPEN UTL_FILE.file_type;
   LIGNE_LU VARCHAR2(2000) :=null ;

   BEGIN
    FILE_OPEN := UTL_FILE.fopen ( 'e:\temp' , F_NAME , 'r' );     LOOP

     BEGIN 
      UTL_FILE.GET_LINE ( FILE_OPEN , LIGNE_LU ); 
      DBMS_OUTPUT.PUT_LINE (LIGNE_LU); 
      -- PARSING (LIGNE_LU,TYPE); 
     EXCEPTION WHEN NO_DATA_FOUND THEN 
      EXIT; 
     END; 

    END LOOP;      UTL_FILE.fclose ( FILE_OPEN );
      EXCEPTION 
        when UTL_FILE.invalid_path         then raise_application_error =
( -20100 , 'Invalid path : "') ; 
        when UTL_FILE.invalid_mode         then raise_application_error =
( -20101 , 'Invalid mode'    ) ; 
        when UTL_FILE.invalid_operation    then raise_application_error =
( -20101 , 'Write operation' ) ; 
     when UTL_FILE.INVALID_FILEHANDLE    then raise_application_error ( =
-20100 , 'INVALID_FILEHANDLE') ; 
     when UTL_FILE.READ_ERROR        then raise_application_error ( =
-20100 , 'READ_ERROR') ; 
     when VALUE_ERROR            then raise_application_error ( -20100 , =
'VALUE_ERROR') ; 
     when others                           then DBMS_OUTPUT.PUT_LINE =
('C''est une autre erreur !!!!!'); 
        UTL_FILE.fclose ( FILE_OPEN ) ; 
    END;
  /
  =

==========================
==========================
==========================
Somebody with already have the same problem, and how to solve it.

  Thank you in advance.

  To afflict for my bad English Received on Thu Feb 24 2000 - 08:52:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US