Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using a utl_file.file_type as a procedure argument

alfonsNov 23 2007 — edited Nov 27 2007
Hi,

I'm trying to pass a utl_file.file_type variable defined in Proc A to ProcB as fllows:

Proc A:

output_file utl_file.file_type;
output_file := utl_file.fopen('E:\tmp\', 'traspas_merma.log', 'W');
call ProcB(output_file);

Proc B:

Procedure ProcB(filestr IN utl_file.file_type) IS
BEGIN
utl_file.put_line(filestr, str);
END;

When I compile I obtain the following error:

PLS-00363 Expression 'FILE' can be used as a destination assignment

So, whoy should I define the ProcB spec?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2007
Added on Nov 23 2007
8 comments
1,070 views