I have a simple test function:
create or replace function put_line_function return string as
begin
dbms_output.put_line('this is some output');
return 'x';
end put_line_function;
in sql developer I
set SERVEROUTPUT ON;
Then I open the DBMS output window
then I call the function in a simple sql:
select put_line_function from dual;
But I never see the DBMS_OUTPUT from the PUT_LINE function
My goal was to have my db functions spit out informational messages when useful to our database team.
Is there a way to do this in oracle user defined functions?
ps: I also had this at the start of my function, but it did not help either:
DBMS_OUTPUT.ENABLE();