Do you know the History of Data Science? READ MORE

Viewing Oracle's 'DBMS_OUTPUT' in Dataiku

Solved!
sandsOfTim
Level 1
Viewing Oracle's 'DBMS_OUTPUT' in Dataiku

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?

0 Kudos
1 Solution
Andrey
Dataiker
Dataiker

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

Andrey Avtomonov
R&D Engineer @ Dataiku

View solution in original post

1 Reply
Andrey
Dataiker
Dataiker

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

Andrey Avtomonov
R&D Engineer @ Dataiku

View solution in original post

A banner prompting to get Dataiku DSS