This content has been marked as final. Show 3 replies
What is your full code? You may not have your file open. there could be any reason.
Please give the below command from your environment and check the output for PUT_LINE
UTL_FILE.PUT_LINE is procedure. You'll get an error if you try using it as a function:
SQL> declare 2 x number; 3 begin 4 x := utl_file.put_line(1,'X'); 5 end; 6 / x := utl_file.put_line(1,'X'); * ERROR at line 4: ORA-06550: line 4, column 10: PLS-00222: no function with name 'PUT_LINE' exists in this scope ORA-06550: line 4, column 5: PL/SQL: Statement ignored SQL>