Viewing Oracle's 'DBMS_OUTPUT' in Dataiku
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
-
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