Oracle Connector Options

Options

• array fetch size
• disable all checks
• disable cache
• disable checks
• disable escape
• disable foreign key rules
• disable hint first_rows
• disable lws close
• disable packages
• disable precompiler connect
• disable rowid
• disable segmented fields
• enhanced numbers
• fetch_lob_as_long
• fixed array size
• ignore missing packages
• map fixed length to variable
• multi byte
• nclob_ext
• nulls last
• open cursors
• step size
• support obsolete 3gl services
• unicode smp
• upgrade packages
• use_timestamp
• uselike
• u36_compatibility
• u4_compatibility
• varchar2_4k

Description

Most connector options enable or disable a specific feature by setting the option. Some options have a numeric parameter which must be a non-negative decimal integer. The range of valid values is option-specific. Every numeric option has a default value.

Every connector option can be specified using either a Long format, which is readable, or a short format, which allows you to set many options in the USYS$ORA_PARAMS assignment.

If the Uniface Application Server is used, the USYS$ORA_PARAMS assignment setting must be in an assignment file on the server platform. The setting must be in an assignment file on the client platform if Oracle is accessed locally or if SQL*Net is used.

USYS$ORA_PARAMS = disable packages, oc 100, af 12
USYS$ORA_PARAMS = step size 20, array fetch size 20, fixed array size
USYS$ORA_PARAMS = dhfr, fa, oc 100, de, im

Syntax Rules

The syntax rules for USYS$ORA_PARAMS are as follows:

• The assignment can be no longer than one line in the assignment file.
• All connector options have the form Directive = Value. Instead of the equal sign (=), a colon can be used.
• Each option may be specified once, either in Long format or in short format, not both. Options in Long format may be mixed with other options in short format.
• The order in which the options are specified is not significant.
• Multiple options must be separated by a comma.
• Words and numbers within one option are separated by one or more spaces and tabs.
• Options are not case-dependent.

Limitations on Oracle Connector Options

Limitations on combining connector options include the following:

• The following combinations of options are not valid:

  • disable packages and ignore missing packages
  • disable packages and upgrade packages
  • disable checks and ignore missing packages

• The following connector errors can be generated because of incorrect assignments to USYS$ORA_PARAMS:

  • Oracle connector Error [-7]: Value out of range: Value
  • Oracle connector Error [-8]: Syntax error or illegal value in USYS$ORA_PARAMS assignment
  • Oracle connector Error [-9]: Invalid combination of connector options in USYS$ORA_PARAMS assignment

• Some examples of correct USYS$ORA_PARAMS assignments are as follows:

  • USYS$ORA_PARAMS = disable packages, oc 100, af 12
  • USYS$ORA_PARAMS = step size 20, array fetch size 20,fixed array size
  • USYS$ORA_PARAMS = dhfr, fa, oc 100, de, im, dsf