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?
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