DBeaver not showing dbms_output

Question

I'm using dbeaver version 5.1.3. When I use the DBMS_OUTPUT.PUT_LINE method for oracle pl/sql it's output not shown anywhere. It has a output tab. It's also blank.

score 49 · Answer 1 · answered Jul 31 '18 at 17:28

49

You can enable server output console. (Ctrl+Shift+O) If you expand the query pane, you are able to see two more buttons. (Server output console e Execution Log)

I can't really tell you the diference between this server output console and the output view tab you show on the print screen above.

answered Jul 31 '18 at 17:28

bserrao

491
1
3
2

2

Is this a comment? – Mathews Sunny Jul 31 '18 at 17:36
Was really unable to find the output in any other way than this one, in DBeaver 6.2.2 version. – student0495 Apr 29 '20 at 15:00

score 14 · Accepted Answer · edited Jun 09 '19 at 07:12

14

Actually you can use DBMA_OUTPUT.PUT_LINE in DBeaver (mine is version 4.3.2), maybe you were just looking at "wrong" output tab. I have attached a screenshot of my SQL editor to make my point clearer.

edited Jun 09 '19 at 07:12

Jake Lee

7,549
8
45
86

answered Jan 10 '19 at 03:50

GreenLake4964

744
9
20

1

Thanks a lot ! by the way, the buttons have move a bit, they are now in the bottom left of the sql query windows as very small squares :). – ykatchou Mar 26 '19 at 14:35
I still do not see any logs in the output tab, is there something I need to enable ? – Scorpy Apr 23 '20 at 10:21
is DBMS_OUTPUT not DBMA_OUTPUT – JRichardsz Jan 26 '21 at 15:55

score 6 · Answer 3 · answered Sep 15 '20 at 05:25

6

shorcut Ctrl+Shift+O

Or You can view the output panel by clicking the 'View Server Output' button.

answered Sep 15 '20 at 05:25

bbokkun

161
2
2

score 1 · Answer 4 · edited Dec 08 '20 at 10:47

1

The second (middle icon) is where you can see the output for your query as per December 2020 Dbeaver latest version.

edited Dec 08 '20 at 10:47

Coursal

1,387
4
17
32

answered Dec 02 '20 at 10:07

NAMAN GUPTA

71
2
12

DBeaver not showing dbms_output

4 Answers4

Linked