PL/SQL general connection attributes

PL/SQL general connection attributes are set by each connection and persist for the duration of the connection. These attributes control the behaviors of the data store. PL/SQL general connection attributes are listed Table 1-6, "PL/SQL general connection attributes" and described in detail in this section.

For more details on this attribute, see the appropriate Oracle 11g documentation.

You can use the ALTER SESSION statement to change PL/SQL parameters to override the values that are assigned to the PL/SQL general connection attributes at connection time. For details, see Oracle TimesTen In-Memory Database SQL Reference.

PLSCOPE_SETTINGS

PLSCOPE_SETTINGS controls whether or not the PL/SQL compiler generates cross-reference information. Either all or no cross-references are generated.

Some things to consider when setting this attribute are:

• The PLSCOPE_SETTINGS connection attribute determines the initial value of this attribute within a session. The value may be modified by an ALTER SESSION statement. If the attribute is specified in an ALTER SESSION statement in a data store where PLSQL=0, an error is returned.

• If this attribute is specified in a connection string or in the odbc.ini file and the application is connecting to a data store where PLSQL=0, no error or warning results.

Required privilege

No privilege is required to change the value of this attribute.

Setting

Set PLSCOPE_SETTINGS as follows:

PLSQL_CCFLAGS

This attribute can be used to set directives to control conditional compilation of PL/SQL units, which allows you to customize the functionality of a PL/SQL program depending on conditions that are checked. This is especially useful when applications may be deployed to multiple database environments. Possible uses include activating debugging or tracing features, or basing functionality on the version of the database.

Use this format:

PLSQL_CCFLAGS = 'v1:c1,v2:c2,...,vn:cn'

vi has the form of an unquoted PL/SQL identifier. It is unrestricted and can be a reserved word or a keyword. The text is insensitive to case. Each one is known as a flag or flag name. Each vi can occur more than once in the string, each occurrence can have a different flag value, and the flag values can be of different kinds.

ci is one of the following: a PL/SQL boolean literal, a PLS_INTEGER literal, or the literal NULL. The text is insensitive to case. Each one is known as a flag value and corresponds to a flag name.

Required privilege

No privilege is required to change the value of this attribute.

Setting

Set PLSQL_CCFLAGS as follows:

You can use the ALTER SESSION SQL statement to change this attribute within a session.

PLSQL_CONN_MEM_LIMIT

This attribute specifies the maximum amount of process heap memory that PL/SQL can use for this connection. Specify the memory size in megabytes.

Some things to consider when setting this attribute are:

• PL/SQL does not allocate this memory until or unless it is needed. Many PL/SQL programs require only a small amount of memory. How you write your application can determine memory requirements. For example, using large VARRAYs in PL/SQL code can require a lot of memory.

• If you attempt to allocate more memory than allowed, TimesTen returns an error.

• The value can be modified with the ALTER SESSION statement.

See Oracle TimesTen In-Memory Database PL/SQL Developer's Guide for more information.

Required privilege

No privilege is required to change the value of this attribute.

Setting

Set PLSQL_CONN_MEM_LIMIT as follows:

PLSQL_OPTIMIZE_LEVEL

This attribute specifies the optimization level to be used to compile PL/SQL library units. The higher the setting of this parameter, the more effort the compiler makes to optimize PL/SQL library units.

Some things to consider when setting this attribute are:

• The PLSQL_OPTIMIZE_LEVEL connection attribute determines the initial value of this attribute within a session. The value may be modified by an ALTER SESSION statement. If the attribute is specified in an ALTER SESSION statement in a data store where PLSQL=0, an error is returned.

• If this attribute is specified in a connection string or in the odbc.ini file and the application is connecting to a data store where PLSQL=0, no error or warning results.

Required privilege

No privilege is required to change the value of this attribute.

Setting

Set PLSQL_OPTIMIZE_LEVEL as follows:

PLSQL_TIMEOUT

This attribute controls how long (in seconds) PL/SQL procedures that do not make any calls to the database itself (such as INSERT, UPDATE or DELETE) are allowed to run before being automatically terminated.

This value may be modified with an ALTER SESSION statement. If this value is modified through ALTER SESSION, the new value impacts any PL/SQL program units that are currently running.

Required privilege

No privilege is required to change the value of this attribute.

Setting

Set PLSQL_TIMEOUT as follows: