Search notes:

Oracle: DBMS_OUTPUT

Send messages from stored procedures (poor man's debugging)

Procedures

`disable`
`enable`
`get_line`
`get_lines`
`get_lines`
`new_line`
`put`
`put_line`

See also

dbms_pipe allows to send messages between two or more sessions.

Oracle DBMS PL/SQL Packages

Turning on dbms_output in SQL Developer.

See also the menu View -> Dbms Output.

dbms_java.set_output

$ORACLE_HOME/rdbms/admin/dbmsotpt.sql

In order to automatically enable dbms_output in SQL Developer, the value of Filename for connection startup script, found under the menu Tools -> Preferences -> Databases might be set to a script that contains set serveroutput on.

outon.sql is a most simple SQL script to be put into a $SQLPATH directory. It «enables» dbms_output in SQL*Plus.

The hOut package (MOS Note 101446.1)

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...', 1788353919, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/output/index(75): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78