Is there any way to flush output from PL/SQL in Oracle?

by

Not really. The way DBMS_OUTPUT works is this: Your PL/SQL block executes on the database server with no interaction with the client. So when you call PUT_LINE, it is just putting that text into a buffer in memory on the server. When your PL/SQL block completes, control is returned to the client (I’m assuming SQLPlus in this case); at that point the client gets the text out of the buffer by calling GET_LINE, and displays it.

So the only way you can make the output appear in the log file more frequently is to break up a large PL/SQL block into multiple smaller blocks, so control is returned to the client more often. This may not be practical depending on what your code is doing.

Other alternatives are to use UTL_FILE to write to a text file, which can be flushed whenever you like, or use an autonomous-transaction procedure to insert debug statements into a database table and commit after each one.

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. PL SQL UPDATE STATEMENT
  3. Splitting string into multiple rows in Oracle
  4. Search All Fields In All Tables For A Specific Value (Oracle)
  5. Is there a combination of “LIKE” and “IN” in SQL?
  6. What is the string concatenation operator in Oracle?
  7. Is it possible to output a SELECT statement from a PL/SQL block?
  8. REGEX to select nth value from a list, allowing for nulls
  9. SQL to generate a list of numbers from 1 to 100
  10. How to use BOOLEAN type in SELECT statement
  11. SQL recursive query on self referencing table (Oracle)
  12. create table with sequence.nextval in oracle [duplicate]
  13. IF EXISTS condition not working with PLSQL
  14. PLS-00428: an INTO clause is expected in this SELECT statement
  15. passing table and column name dynamically using bind variables
  16. WHERE IN condition not accepting String value
  17. Sleep function in ORACLE
  18. Solution to “cannot perform a DML operation inside a query”?
  19. Array in IN() clause oracle PLSQL
  20. PLSQL Insert into with subquery and returning clause
  21. What does the colon sign “:” do in a SQL query?
  22. How to query a CLOB column in Oracle
  23. Oracle (Old?) Joins – A tool/script for conversion?
  24. Advice Using Pivot Table in Oracle
  25. Creating or simulating two dimensional arrays in PL/SQL
  26. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  27. Subtracting Dates in Oracle – Number or Interval Datatype?
  28. How to call Oracle MD5 hash function?
  29. ORACLE After update trigger: solving ORA-04091 mutating table error
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment