Loading....

To test if the utl_file_dir path in the init.ora file can indeed be written to .

Login as sysdba –

1. Create a test procedure

CREATE OR REPLACE procedure utl_file_test_write (
path in varchar2,
filename in varchar2,
firstline in varchar2,
secondline in varchar2)
is
output_file utl_file.file_type;
begin
output_file := utl_file.fopen (path,filename, ‘W’);

utl_file.put_line (output_file, firstline);
utl_file.put_line (output_file, secondline);
utl_file.fclose(output_file);

–exception
— when others then null;
end;
/

Now run a test –

begin
utl_file_test_write (
‘/tmp’,
‘utl_file_test’,
‘first line’,
‘second line’
);
end;
/

If ‘/tmp’ is not a part of the UTL_FILE_DIR path in the init.ora, then this test will fail.

Please follow and like us:

Last Update: July 10, 2009  

July 10, 2009 228 Arjun Raja
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

,

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?