ORACLE OPTION — set oracle option
ORACLE OPTION (option_name=option_value)
ORACLE OPTION sets an oracle option, three options are currently supported, RELEASE_CURSOR, ORACA and CHAR_MAP.
The RELEASE_CURSOR and ORACA 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 34.6. Oracle Option Sets
| option_name | option_value |
|---|---|
RELEASE_CURSOR | YES | NO |
CHAR_MAP | STRING |
ORACA | YES | NO |
option_nameThe name of option.
option_valueA value of option.
EXEC ORACLE OPTION (RELEASE_CURSOR=YES); EXEC ORACLE OPTION (RELEASE_CURSOR=NO); EXEC ORACLE OPTION (CHAR_MAP=STRING); EXEC ORACLE OPTION (ORACA = YES); EXEC ORACLE OPTION (ORACA = NO);