My Oracle Support Banner

set serveroutput on does not work in an initblock. (Doc ID 2380531.1)

Last updated on OCTOBER 17, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.