CODEWITHSUNDEEP
dbeaver
Indika Rajapaksha
Indika Rajapaksha

Reputation: 1168

DBeaver not showing dbms_output

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.

enter image description here

Upvotes: 30

Views: 53864

Answers (5)

armyofda12mnkeys
armyofda12mnkeys

Reputation: 3442

Note: for me i had to run my PL/SQL (DECLARE/BEGIN/END statement) as 'Execute SQL Query' instead of 'Execute Script'. I thought an dbms_output.put_line would work in either (in fact thought Script would work better for PL/SQL scripts) but alas it didn't.

Upvotes: 0

NAMAN GUPTA
NAMAN GUPTA

Reputation: 101

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

Upvotes: 2

bbokkun
bbokkun

Reputation: 191

shorcut Ctrl+Shift+O

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

enter image description here

Upvotes: 8

GreenLake4964
GreenLake4964

Reputation: 776

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.

enter image description here

Upvotes: 15

bserrao
bserrao

Reputation: 551

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.

Upvotes: 55

Related Questions