utl_file in ORACLE

Database

utl_file in ORACLE


Hi,

this is gopi...

help me in understand the below ORACLE Fun. & the same need conversion into TERADATA...

utl_file.put_line(gv_logfile_handle,gv_err_mesg);
utl_file.fflush(gv_logfile_handle);
utl_file.fclose(gv_logfile_handle);
1 REPLY
Teradata Employee

Re: utl_file in ORACLE

these are stored procedure functions. Teradata does not support displaying values from within a stored procedure (except for the output parameters). You can insert into a work table to capture output.

Maybe there is a better way to do it. What are you trying to accomplish?