Search notes:

SQLPATH - spooling helpers

spool.sql sets some SQL*Plus settings in a way, that the spool command writes clean files. These files are used, for example, in insert_statement_creator.sql.

spool.sql

Start spooling in a clean way: 
--  Change settings so that output printed to
--  SQL*Plus (via dbms_output.put_line) can
--  be spooled into a file without headers
--  or other distracting features.
--
--  developed to be used along with dot.sql
--
set feedback off
set echo off
set trimspool on
set termout off
set lines 500
set pages 0
spool &1
Github repository Oracle-SQLPATH, path: /spool.sql

spool_off.sql

End spooling 
--
--    closes the spooling initiated by ./spool.sql
--
spool off
set lines            190
set pages           5000
set termout           on
Github repository Oracle-SQLPATH, path: /spool_off.sql

See also

Oracle: files for ORACLE_PATH / SQLPATH

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:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758198437, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL-Plus/sqlpath/spool(75): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78