Use dbms_output.put_line in Datagrip for .sql files

oracle plsql datagrip dbms-output
Cezar Cobuz picture Cezar Cobuz · Apr 2, 2018 · Viewed 7k times · Source

I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMS_OUTPUT.PUT_LINE. Before this I was using Oracle SQL developer and I was able to use DBMS_OUTPUT by adding the following: 

SET serveroutput ON;

There is a related question that shows how to enable or disable showing the contents of the DBMS_OUTPUT buffer but this only works for the Database Console tool window. How can I apply this to any .sql file? Currently, I am copying the content of my .sql files and run it in the Console tool window but there must be a better way.

Answer

moscas picture moscas · Apr 2, 2018

Turn on this setting in the Output pane: enter image description here

Related questions

Does DataGrip by JetBrains support PL/SQL development?

JetBrains website displays multiple useful features of their Database IDE, including code generation as per https://www.jetbrains.com/datagrip/features/generation.html; However the website does not explicitly declare support for PL/SQL. Can any DataGrip users give a …

Read More
SQL error "ORA-01722: invalid number"

A very easy one for someone, The following insert is giving me the ORA-01722: invalid number why? INSERT INTO CUSTOMER VALUES (1,'MALADY','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES (2,'GIBSON','Jake','27 Smith St Caulfield','0415 713 598…

Read More
Is there a combination of "LIKE" and "IN" in SQL?

In SQL I (sadly) often have to use "LIKE" conditions due to databases that violate nearly every rule of normalization. I can't change that right now. But that's irrelevant to the question. Further, I often use conditions like WHERE something …

Read More