upgrade fetch procedures

Specify whether the connector will use stored procedures that work with paranoid locking.

USYS$MSS_PARAMS {=} upgrade fetch procedures = on | off

USYS$MSS_PARAMS {=} ufp = on | off

Use

This setting must be used with procedures=on.

Description

Normal stored procedures do not work when paranoid locking is used (Fetch mode 1).

When set on, the Create Table facility generates create procedure commands on the fly at the same time tables are created.

USYS$MSS_PARAMS = procs=on, ufp=on

Related Topics