Viewing Oracle's 'DBMS_OUTPUT' in Dataiku

sandsOfTim
sandsOfTim Registered Posts: 1 ✭✭✭

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?

Best Answer

  • Andrey
    Andrey Dataiker Alumni Posts: 119 ✭✭✭✭✭✭✭
    edited July 17 Answer ✓

    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

Setup Info
    Tags
      Help me…