Hi all,
I am loading an Oracle V7.3.4 table from a flat file using the UTL file package. This flat file is transferred from a mainframe to a Windows NT4, Pack 6 server.
During the transfer, some caracters are converted. For example, the word "PRêt" becames "PR T" and in this case the end of line is not detected by Oracle when reading the file line by line with the following Oracle function :
Create or replace function MY_GET_LINE (file_handle IN UTL_FILE.FILE_TYPE,ligne OUT VARCHAR2) RETURN boolean IS
BEGIN
UTL_FILE.GET_LINE(file_handle, ligne);
RETURN TRUE;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN FALSE;
WHEN OTHERS THEN
RAISE;
END MY_GET_LINE;
/
Your expertise is welcome.
Palmero.
I am loading an Oracle V7.3.4 table from a flat file using the UTL file package. This flat file is transferred from a mainframe to a Windows NT4, Pack 6 server.
During the transfer, some caracters are converted. For example, the word "PRêt" becames "PR T" and in this case the end of line is not detected by Oracle when reading the file line by line with the following Oracle function :
Create or replace function MY_GET_LINE (file_handle IN UTL_FILE.FILE_TYPE,ligne OUT VARCHAR2) RETURN boolean IS
BEGIN
UTL_FILE.GET_LINE(file_handle, ligne);
RETURN TRUE;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN FALSE;
WHEN OTHERS THEN
RAISE;
END MY_GET_LINE;
/
Your expertise is welcome.
Palmero.