ORACLE OPTION

ORACLE OPTION
Prev	Up	33.14. Embedded SQL Commands	Home	Next

ORACLE OPTION — set oracle option

Synopsis

ORACLE OPTION (option_name=option_value)

Description

ORACLE OPTION sets an oracle option, two options are currently supported, RELEASE_CURSOR and CHAR_MAP. The RELEASE_CURSOR option is currently just a syntactic sugar. When CHAR_MAP is set to STRING, character arrays are guaranteed to be NULL-terminated, but only one-dimensional arrays are supported.

Table 33.6. Oracle Option Sets

option_name	option_value
`RELEASE_CURSOR`	YES \| NO
`CHAR_MAP`	STRING

Parameters

option_name: The name of option.
option_value: A value of option.

Examples

EXEC ORACLE OPTION (RELEASE_CURSOR=YES);
EXEC ORACLE OPTION (RELEASE_CURSOR=NO);
EXEC ORACLE OPTION (CHAR_MAP=STRING);