Daily we need to get some 40 records in to a file on Unix. I could use either of UTK_FILE and spool. Which is better and in what sense (like performance, reliability etc).
They're kind of neutral, but utl_file requires a bit more effort to implement.
Typically to do something like this I'd have a script to spool it to file. The script could be initiated by user request or run out of an AT or a cron command. Don't forget to spool off, either....
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.