2

I'm pretty new to DbVisualizer (v6.5.5) and have been trying to get even a basic loop to return some results. Just something I can build off of but no luck and I can't seem to find anything online that helps. This query executes successfully (no error) but doesn't show any results. What am I missing? Database is Oracle 11g.

--/
DECLARE
  a number(2);
   BEGIN
     FOR a in 1 .. 20 LOOP
     dbms_output.put_line('value of a: ' || a);
   END LOOP;
 END;
/

How can I get them to show up?

N1tr0
  • 485
  • 2
  • 6
  • 24

1 Answers1

4

First I suggest you upgrade to the latest 9.1 version since 6.5.5 is very old.

Secondly, to take care of DBMS_OUTPUT calls you need the DbVisualizer Pro edition with support for this feature. If you don't have a license for DbVisualizer Pro, sign-up using v9.1 and in the Help->Evaluate Pro Edition.

Once DbVisualizer Pro 9.1 is running, there is a DBMS Output tab that will appear in the SQL Commander for your Oracle connection.

Hope this helps.

roger
  • 641
  • 4
  • 7
  • 1
    Thanks roger. Unfortunately this is a work computer and I don't have the ability to upgrade it. :( – N1tr0 Sep 18 '13 at 13:51
  • On the [official documentation](http://confluence.dbvis.com/display/UG/Using+the+DBMS+Output+Tab) there is some info about the DBMS Output, but nothing about Pro Edition. It was driving me crazy. Thanks again, roger. – Dinei May 22 '17 at 15:55