Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
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