Printing the value of a variable in SQL Developer

Question

I wanted to print the value of a particular variable which is inside an anonymous block  I am using Oracle SQL Developer  I tried using dbms output put line  But it is not working  The code which I am using is shown below   SET SERVEROUTPUT ON  DECLARE    CTABLE USER OBJECTS OBJECT NAME TYPE    CCOLUMN ALL TAB COLS COLUMN NAME TYPE    V ALL COLS VARCHAR2 500      CURSOR CURSOR TABLE     IS     SELECT OBJECT NAME      FROM USER OBJECTS      WHERE OBJECT TYPE  TABLE      AND OBJECT NAME LIKE  tb prm        CURSOR CURSOR COLUMNS  V TABLE NAME IN VARCHAR2      IS     SELECT COLUMN NAME     FROM ALL TAB COLS     WHERE TABLE NAME   V TABLE NAME   BEGIN    OPEN CURSOR TABLE     LOOP     FETCH CURSOR TABLE INTO CTABLE      EXIT WHEN CURSOR TABLE NOTFOUND       OPEN CURSOR COLUMNS  CTABLE        V ALL COLS    NULL       LOOP       FETCH CURSOR COLUMNS INTO CCOLUMN        V ALL COLS    V ALL COLS    CCOLUMN        IF CURSOR COLUMNS FOUND THEN         V ALL COLS    V ALL COLS                ELSE         EXIT        END IF      END LOOP       DBMS OUTPUT PUT LINE V ALL COLS      END LOOP    CLOSE CURSOR TABLE   END    And I am getting the output only as anonymous block completed

User · Accepted Answer

You need to turn on dbms output  In Oracle SQL Developer    Show the DBMS Output window  View- DBMS Output   Press the     button at the top of the Dbms Output window and then select an open database connection in the dialog that opens    In SQL Plus    SET SERVEROUTPUT ON

User · Answer

There are 2 options   set serveroutput on format wrapped    or   Open the  view  menu and click on  dbms output   You should get a dbms output window at the bottom of the worksheet  You then need to add the connection  for some reason this is not done automatically

User · Answer

Make server output on First of all   SET SERVEROUTPUT on then Go to the DBMS Output window  View- DBMS Output  then Press Ctrl N for connecting server

User · Answer

DECLARE    CTABLE USER OBJECTS OBJECT NAME TYPE    CCOLUMN ALL TAB COLS COLUMN NAME TYPE    V ALL COLS VARCHAR2 5000      CURSOR CURSOR TABLE     IS     SELECT OBJECT NAME      FROM USER OBJECTS      WHERE OBJECT TYPE  TABLE      AND OBJECT NAME LIKE  STG       CURSOR CURSOR COLUMNS  V TABLE NAME IN VARCHAR2      IS     SELECT COLUMN NAME     FROM ALL TAB COLS     WHERE TABLE NAME   V TABLE NAME   BEGIN    OPEN CURSOR TABLE    LOOP     FETCH CURSOR TABLE INTO CTABLE       OPEN CURSOR COLUMNS  CTABLE       V ALL COLS    NULL      LOOP        FETCH CURSOR COLUMNS INTO CCOLUMN        V ALL COLS    V ALL COLS    CCOLUMN        IF CURSOR COLUMNS FOUND THEN         V ALL COLS    V ALL COLS                ELSE         EXIT        END IF      END LOOP     close CURSOR COLUMNS       DBMS OUTPUT PUT LINE V ALL COLS       EXIT WHEN CURSOR TABLE NOTFOUND    END LOOP  enter code here    CLOSE CURSOR TABLE   END    I have added Close of second cursor  It working and getting output as well

User · Answer

SQL Developer seems to only output the DBMS OUTPUT text when you have explicitly turned on the DBMS OUTPUT window pane   Go to  Menu  VIEW -  Dbms output to invoke the pane   Click on the Green Plus sign to enable output for your connection and then run the code   EDIT  Don t forget to set the buffer size according to the amount of output you are expecting

User · Answer

select View-- DBMS Output in menu and

User · Answer

Go to the DBMS Output window  View- DBMS Output

User · Answer

1   Go to view menu  2   Select the DBMS OUTPUT menu item  3   Press Ctrl   N and select connection editor   4   Execute the SET SERVEROUTPUT ON Command  5   Then execute your PL SQL Script

[oracle] Printing the value of a variable in SQL Developer

Examples related to oracle

Examples related to plsql

Examples related to oracle-sqldeveloper