hi all

From: mamta81 <roy.mamta_at_gmail.com>
Date: Wed, 14 Nov 2007 06:38:22 -0000
Message-ID: <1195022302.015831.103200@v29g2000prd.googlegroups.com>

i am getting the following errors when i am running the following procedure
CREATE OR REPLACE
PROCEDURE UREAD AS
BEGIN
declare
f utl_file.file_type;
str varchar2(50);

  begin
  f := utl_file.fopen('PAYROLL_DIR','someone_new', 'r');   utl_file.GET_LINE(f,str);
  utl_file.fclose(f);
  EXCEPTION
  WHEN utl_file.invalid_path THEN
    RAISE_APPLICATION_ERROR(-20001, 'utl_file.invalid_path');   WHEN utl_file.invalid_mode THEN
    RAISE_APPLICATION_ERROR(-20001, 'utl_file.invalid_mode');   WHEN utl_file.invalid_filehandle THEN
    RAISE_APPLICATION_ERROR(-20001, 'utl_file.invalid_filehandle');   WHEN utl_file.invalid_operation THEN
    RAISE_APPLICATION_ERROR(-20001, 'utl_file.invalid_operation');   WHEN utl_file.read_error THEN

    RAISE_APPLICATION_ERROR(-20001, 'utl_file.read_error');
  WHEN utl_file.write_error THEN
    RAISE_APPLICATION_ERROR(-20001, 'utl_file.write_error');

  WHEN utl_file.internal_error THEN
    RAISE_APPLICATION_ERROR(-20001, 'utl_file.internal_error');   WHEN OTHERS THEN
    RAISE_APPLICATION_ERROR(-20001, 'utl_file.other_error');   end;
END UREAD;

ORA-20001: utl_file.invalid_operation
ORA-06512: at "PAYROLL.UREAD", line 19
ORA-06512: at line 2

Received on Wed Nov 14 2007 - 00:38:22 CST