All geek questions in one place

How to set server output in DataGrip

How can I " set server output " in the Jetbrains DataGrip IDE? I can do this in SQL Developer and successfully run the SQL script. The same script I'm trying to run in a DataGrip, and it gives an error. I know its " set server output to ", which does not work, because I had to configure SQL Developer for it to work. Any advice would be appreciated. Thank you

+5
source share
2 answers

According to the documentation :

For Oracle, you can enable or disable the display of the contents of the DBMS_OUTPUT buffer in the output panel. To do this, use button on the toolbar of the database console tool window ( Ctrl + F8 ).

They also show an image of a window with a button on;

2

+10
source

Server output is client-side functionality that not all clients support. SQL * Plus and SQL Developer, but that’s not what any other client will be.

The SQL * Plus client command set serveroutput on essentially calls the DBMS_OUTPUT.enable() stored procedure on your behalf. In addition, it signals the client, which must check the DBMS_OUTPUT.get_lines() procedure for cached output after each block of code is executed.

If DataGrip does not, you can manually program calls to DBMS_OUTPUT.enable() and DBMS_OUTPUT.get_lines() as needed.

0
source

Source: https://habr.com/ru/post/1262378/

More articles:


All Articles