writing output from Pl/SQL o txt file

[anithas]

I need to write the o/p from an Oracle Pl/SQL to a txt file.

I tried the following , but i get an error
declare
f utl_file.file_type;
s varchar2(200) := 'this is some info';
begin
f := utl_file.fopen('SAMPLEDATA','sample2.txt','W');
utl_file.put_line(f,s);
utl_file.fclose(f);
end;


error is : r): ORA-29280: invalid directory path ORA-06512: at "SYS.UTL_FILE", line 18 ORA-06512: at "SYS.UTL_FILE", line 424 ORA-06512: at line 5

I tried to give the location path of the file as "c:\temp"------> the physical location of the file in a remote pc im working on......kindly help me

[metrey]

I'm also new to PL/SQL. As I know it is because of your directory path object "SAMPLEDATA" is not define, you need to create this object directory with full read/write. For example:

CREATE DIRECTORY SAMPLEDATA as '/srv02/logfiles';
GRANT READ, WRITE ON DIRECTORY SAMPLEDATA TO YOUR_SCHEMA_USER1, YOUR_SCHEMA_USER2, system;

But you need to have full right access in your oracle db to use this command.

Hope it will help. And please others help to correct if have mistake.