DBMS OUTPUT PUT LINE not printing

Question

When executing the following code  it just says the procedure is completed and doesn t print the infomation i want it to  firstName  lastName  and then the other values from the select query in a table below    CREATE OR REPLACE PROCEDURE PRINT ACTOR QUOTES  id actor char  AS CURSOR quote recs IS SELECT a firstName a lastName  m title  m year  r roleName  q quotechar from quote q  role r     rolequote rq  actor a  movie m where rq quoteID   q quoteID AND rq roleID   r roleID  AND r actorID   a actorID AND r movieID   m movieID AND  a actorID   id actor  BEGIN FOR row IN quote recs LOOP DBMS OUTPUT PUT LINE  a firstName      a lastName     end loop  END PRINT ACTOR QUOTES       When setting server output on  I get   a firstNamea lastName a firstNamea lastName a firstNamea lastName a firstNamea lastName   multiple times

User · Answer

For SQL Developer

You have to execute it manually

SET SERVEROUTPUT ON

After that if you execute any procedure with DBMS_OUTPUT.PUT_LINE('info'); or directly .

This will print the line

And please don't try to add this

 SET SERVEROUTPUT ON

inside the definition of function and procedure, it will not compile and will not work.

User · Answer

All of them are concentrating on the for loop but if we use a normal loop then we had to use of the cursor record variable  The following is the modified code   CREATE OR REPLACE PROCEDURE PRINT ACTOR QUOTES  id actor char      AS     CURSOR quote recs IS     SELECT a firstName a lastName  m title  m year  r roleName  q quotechar from quote q  role r         rolequote rq  actor a  movie m     where     rq quoteID   q quoteID     AND     rq roleID   r roleID      AND     r actorID   a actorID     AND     r movieID   m movieID     AND      a actorID   id actor      recd quote recs rowtype      BEGIN     open quote recs      LOOP     fetch quote recs into recs      exit when quote recs notfound      DBMS OUTPUT PUT LINE recd firstName  recd lastName       end loop      close quote recs      END PRINT ACTOR QUOTES

User · Answer

Set Query as below at first line   SET SERVEROUTPUT ON

User · Answer

I am using Oracle SQL Developer    In this tool  I had to enable DBMS output to view the results printed by  dbms output put line   You can find this option in the result pane where other query results are displayed   so  in the result pane  I have 7 tabs  1st tab named as Results  next one is Script Output and so on  Out of this you can find a tab named as  DBMS Output  select this tab  then the 1st icon  looks like a dialogue icon  is Enable DBMS Output  Click this icon  Then you execute the PL SQL  then select  DBMS Output tab  you should be able to see the results there

User · Answer

Ensure that you have your Dbms Output window open through the view option in the menubar  Click on the green     sign and add your database name  Write  DBMS OUTPUT ENABLE   within your procedure as the first line  Hope this solves your problem

User · Answer

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 gt  set serveroutput on size 30000  SQL gt  exec print actor quotes   lt  lt some value gt  gt       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

User · Answer

this statement        DBMS OUTPUT PUT LINE  a firstName      a lastName      means to print the string as it is   remove the quotes to get the values to be printed So the correct syntax is   DBMS OUTPUT PUT LINE a firstName    a lastName

[plsql] DBMS_OUTPUT.PUT_LINE not printing

Examples related to plsql

Examples related to oracle10g

Examples related to sqlplus

Examples related to dbms-output