Re: hi all

On 14 Nov., 07:38, mamta81 <roy.ma..._at_gmail.com> wrote:
> 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

looking up in oracle manual:

"INVALID_OPERATION File could not be opened or operated on as requested."

Well, what could this mean ... Received on Wed Nov 14 2007 - 10:42:30 CST