Viewing Oracle's 'DBMS_OUTPUT' in Dataiku

[sandsOfTim]

We have a number of Oracle SQL packages that provide feedback and results through the use of 'DBMS_OUTPUT.put_line('My Message text')'.

I can view those messages in Oracle SQL_DEVELOPER, but am not sure if I can also view them in Dataiku.

Has anyone been able to view the DBMS_OUTPUT within Dataiku, or do I have to use a more Oracle specific tool?

[Andrey · Accepted solution]

Hi @sandsOfTim ,

There's no special support for PL/SQL in DSS, but it's possible to retreive the DBMS_OUTPUT for example like this:

create or replace procedure testout as
begin
    dbms_output.put_line('Hello world!');
end;

-- DKU_END_STATEMENT


create or replace function debug_testout return varchar2 is
    v_line   varchar2(4000);
    v_status number;
begin
    DBMS_OUTPUT.ENABLE(NULL);
    testout();
    dbms_output.get_line(v_line, v_status);
    return v_line;
end;

-- DKU_END_STATEMENT


select debug_testout()
from dual;

Regards