I'm working in a host company and I'm accessing a remote database using a program called solyp SQL developer. I have to obtain data from stored PLSQL procedures. The data is output from the procedures by dbms_output. The problem is I don't find a way in this client to capture the dbms_output buffer, or an equivalent to "set serveroutput on" for SQL*Plus. I can see results from normal SQL queries but not from PLSQL procedures.
I don't have permission to install other DB clients.
I don't have permission to modify the procedures to generate output way other than than dbms_output.
My question is how can I capture the output of the procedures from the client?
Is there a way to redirect the output of the dbms_output to standard output for a session? or even for the whole DB?
An equivalent to "set serveroutput on" not specific to sQL*Plus?
*dbms_output.enable makes no difference, it only enables dbms_output not redirect it.
*redirecting to a file on the DB server won't work, I don't have access to filesystem on the DB server.