My Oracle Support Banner

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 11.1.1.7.140715 and later
Information in this document applies to any platform.

Symptoms

 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;

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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