set serveroutput on in oracle procedure

Question

I ve created a simple procedure  In this procedure i want to output some data  However where ever i put      set serveroutput on  it says   Error 26 5   PLS-00103  Encountered the symbol  SERVEROUTPUT  when expecting one of the following                     amp    -    lt      at in is mod remainder not rem         lt   or    or        lt    lt   and or like like2    like4 likec as between    multiset member submultiset   It doesn t matter where i put it  it keeps saying it   create or replace PROCEDURE discount    is --- signature   BEGIN --- executable part  update dvd set me our price   me our price 0 90 WHERE me release year   2011  update dvd set me our price   me our price 0 80 WHERE me release year   2010   update bluray set me our price   me our price 0 95 WHERE me release year   2011  update bluray set me our price   me our price 0 90 WHERE me release year   2010    DBMS OUTPUT PUT LINE   Blurays      for i in    SELECT e mo title  e mo bluray me list price as me list price  e mo bluray me our price    as  me our price FROM movie e  where e mo bluray is not null     loop   DBMS OUTPUT PUT LINE i mo title           i me list price           i me list price     end loop    DBMS OUTPUT PUT LINE   DVDs      for i in    set serveroutput on SELECT e mo title  e mo dvd me list price as me list price  e mo dvd me our price as      me our price FROM movie e  where e mo dvd is not null     loop  DBMS OUTPUT PUT LINE i mo title           i me list price           i me list price    end loop     END discount

User · Answer

SET serveroutput ON  is a SQL Plus command and is not valid PL SQL

User · Answer

To understand the use of  SET SERVEROUTPUT ON   I will take an  example  DECLARE a number 10     10  BEGIN dbms output put line a    dbms output put line  Hello World         END     With an output   PL SQl procedure successfully completed i e without the expected output  And the main reason behind is that  whatever we pass inside dbms output put line   ARGUMENT   VALUES  i e  ARGUMENT VALUES   is  internally stored inside a buffer in SGA Shared Global Area   memory area upto 2000 bytes     NOTE     However one should note that this buffer is only created when we use   dbms output package  And we need to set the environment variable only once for a session     And in order to fetch it from that buffer we need to set the environment variable for the session   It makes a lot of confusion to the beginners that we are setting the server output on   because of its nomenclature     but unfortunately its nothing like that   Using SET SERVER OUTPUT ON are just telling the PL SQL engine that   Hey please print the ARGUMENT VALUES that I will be passing inside dbms output put line and in turn PL SQl run time engine prints the argument on the main console    I think I am clear to you all   Wish you all the best   To know more about it with the architectural structure of Oracle Server Engine  you can see my answer on Quora http   qr ae RojAn8  And to answer your question  One should use SET SERVER OUTPUT in the beginning of the session

User · Answer

Procedure successful but any outpout  Error line1  Unexpected identifier   Here is the code   SET SERVEROUTPUT ON   DECLARE      -- Curseurs      CURSOR c1 IS             SELECT RWID FROM J EVT      WHERE DT SYST  lt  TO DATE TO CHAR SYSDATE  DD MM             TO CHAR TO NUMBER TO CHAR SYSDATE   YYYY    - 3         -- Collections       TYPE tc1 IS TABLE OF c1 RWTYPE       -- Variables de type record     rtc1                        tc1           vCpt                        NUMBER  0   BEGIN      OPEN c1      LOOP         FETCH c1 BULK COLLECT INTO rtc1 LIMIT 5000           FORALL i IN 1  rtc1 COUNT          DELETE FROM J EVT           WHERE RWID   rtc1 i  RWID          COMMIT           -- Nombres lus   5025651         FOR i IN 1  rtc1 COUNT LOOP                            vCpt    vCpt   SQL BULK RWCOUNT i           END LOOP                       EXIT WHEN c1 NOTFOUND         END LOOP      CLOSE c1      COMMIT       DBMS OUTPUT PUT LINE   Nombres supprimes        TO CHAR vCpt      END    exit

User · Answer

If you want to execute any procedure then firstly you have to set serveroutput on in the sqldeveloper work environment like   - gt   SET SERVEROUTPUT ON  - gt  BEGIN dbms output put line   Hello World      dbms output put line  Its displaying the values only for the Testing purpose    END

User · Answer

Actually  you need to call SET SERVEROUTPUT ON  before the BEGIN call   Everyone suggested this but offers no advice where to actually place the line   SET SERVEROUTPUT ON   BEGIN     FOR rec in  SELECT   FROM EMPLOYEES  LOOP         DBMS OUTPUT PUT LINE rec EmployeeName       ENDLOOP  END    Otherwise  you won t see any output

User · Answer

First add next code in your sp   BEGIN     dbms output enable        dbms output put line   TEST LINE     END    Compile your code in your Oracle SQL developer  So go to Menu View--  dbms output  Click on Icon Green Plus and select your schema  Run your sp now

[oracle] set serveroutput on in oracle procedure

Examples related to oracle

Examples related to procedure