Answer Posted / avi007
DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
fileHandler := UTL_FILE.FOPEN('/tmp', 'myfile', 'W');
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;
/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is sql better than excel?
What is a loop in sql?
How do I remove sql plus from windows 10?
What are sql triggers used for?
What is native sql query?
What are stored procedures used for?
What is an index in sql with example?
What is sql injection owasp?
Can a select statement fire a trigger?
what is the difference between group by and order by in sql? : Sql dba
How do I view a view in sql?
How do you change a value in sql?
What are sql*plus environment variables?
What is sql exception?
Does sql*plus also have a pl/sql engine?