Error when run a procedure

[jcasas23]

I receive this error message:
The following error has occurred:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 98
ORA-06512: at "SYS.UTL_FILE", line 157
ORA-06512: at "ES344.AR_AREXDESA", line 146
ORA-06512: at line 9

and this is the lines where I am using that sentence:
declare
v_FILE UTL_FILE.FILE_TYPE;
begin
v_file := UTL_FILE.FOPEN( V_OutDir, 'AREXDESA.out','w');
UTL_FILE.PUT_LINE( v_file,V_TRAN_TYP ||',' ||V_ACCTG_PERD);
UTL_FILE.FCLOSE( v_File);
.
.
.
end;


Thanks in advance

 

[karluk]

It looks as if you have an error trying to open the file, but haven't included an error handler in your procedure. Please do so - it should give you better diagnostics about what the problem really is. For an example of the kind of code in a utl_file exception handler take a look at thread186-496465.

 

[SantaMufasa]

Karl,

I'm completely off-topic here, but: Where have you been? We've missed you, bud ! Welcome back. (You can Red-Flag my post here after you have seen my "Welcome Back".)

Cheers,

Mufasa
(aka Dave of Sandy, Utah, USA)
@ 00:23 (23Oct04) UTC (aka "GMT" and "Zulu"),
@ 17:23 (22Oct04) Mountain Time