set serveroutput on does not work in an initblock.
(Doc ID 2380531.1)
Last updated on MAY 07, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 188.8.131.52.140715 and later
Information in this document applies to any platform.
Why does SET SERVEROUTPUT command not work in an init block ?
The same was executing fine and giving results in SQL Developer where as from RPD it's giving below error:
[nQSError:17011]: SQL statement execution failed [nQSError:17001]: Oracle Error Code: 922, message: ORA-00922:missing or invalid option at OCI call OCIStmtExceute: set serveroutput size 100000;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!