Answer Posted / guru
__________________________________________________________
DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
fileHandler := UTL_FILE.FOPEN('/tmp', 'myfile', 'R');
UTL_FILE.PUTF(fileHandler, 'Look ma, I''m writing to a
file!!!\n');
UTL_FILE.FCLOSE(fileHandler);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: Invalid path
for file or path not in INIT.ORA.');
END;
/
________________________________________________________
Thanks
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain autonomous transaction.
What is the unique index?
Where the sql database files are stored?
What is oracle sql developer?
Is inner join faster than left join?
What is a function in oracle pl sql?
how to check myisam tables for errors? : Sql dba
What jobs use sql?
What is difference between sql and oracle?
What is crud sql?
explain commit and rollback in mysql : sql dba
How many clustered indexes can you have?
How you improve the performance of sql*loader? : aql loader
What are two statement types in sql?
What is procedure in pl sql?