Search notes:

Oracle: UTL_FILE.FOPEN

declare
   fh  utl_file.file_type;
begin
  
   fh := utl_file.fopen(
            location     => 'THE_DIRECTORY',
            filename     => 'the-file.txt',
            open_mode    => 'r',
            max_linesize =>  32767              -- Default is 1024
   );

OPENMODE

The value of open_mode can be set to
r to read text
w to write text (creates file)
a to append text (create file if it doesn't exist)
In addtition, a b can be appended to these three values to indicate byte mode.

See also

utl_file

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788640916, '216.73.216.30', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/utl/file/api/fopen(59): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51