DBMS_OUTPUT.PUT_LINE not printing

by

What is “it” in the statement “it just says the procedure is completed”?

By default, most tools do not configure a buffer for dbms_output to write to and do not attempt to read from that buffer after code executes. Most tools, on the other hand, have the ability to do so. In SQL*Plus, you’d need to use the command set serveroutput on [size N|unlimited]. So you’d do something like

SQL> set serveroutput on size 30000;
SQL> exec print_actor_quotes( <<some value>> );

In SQL Developer, you’d go to View | DBMS Output to enable the DBMS Output window, then push the green plus icon to enable DBMS Output for a particular session.

Additionally, assuming that you don’t want to print the literal “a.firstNamea.lastName” for every row, you probably want

FOR row IN quote_recs
LOOP
  DBMS_OUTPUT.PUT_LINE( row.firstName || ' ' || row.lastName );
END LOOP;

More Related Contents:

  1. Create an Oracle function that returns a table
  2. ORA-06550: line 13, column 4: PLS-00103: Encountered the “UPDATE” ORA-06550: line 15, column 3: PLS-00103: Encountered the symbol “END”
  3. Can we use a parameter in a pl sql subprogram other than in where clause
  4. Is it possible to output a SELECT statement from a PL/SQL block?
  5. How to use BOOLEAN type in SELECT statement
  6. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  7. How to kill a running SELECT statement
  8. check if “it’s a number” function in Oracle
  9. Is there any way to flush output from PL/SQL in Oracle?
  10. SQL*Plus how to accept text variable from prompt?
  11. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  12. How to split array list into equal parts?
  13. dbms_output.put_line
  14. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  15. Function return sys_refcursor call from sql with specific columns
  16. How to View Oracle Stored Procedure using SQLPlus?
  17. Receive an unexpected symbol error in my PLSQL query [closed]
  18. null vs empty string in Oracle [duplicate]
  19. What is the difference between function and procedure in PL/SQL?
  20. Sql*plus always returns exit code 0?
  21. Need to reset the value of sequence in Oracle
  22. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  23. PLSQL Insert into with subquery and returning clause
  24. if (select count(column) from table) > 0 then
  25. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  26. Is there a function to split a string in Oracle PL/SQL?
  27. C#: Oracle Data Type Equivalence with OracleDbType
  28. How to insert a string which contains an “&”
  29. Subtracting Dates in Oracle – Number or Interval Datatype?
  30. Escaping single quote in PLSQL

Leave a Comment