Control parameters
The following parameters are defined by mmoci:
Enable/disable "commit on success" in OCI.
|
|
Enable automatic indexation of arrays.
|
|
Data buffer size.
|
|
Maximum string length.
|
|
Identification number of the active OCI connection.
|
|
Enable/disable debug mode.
|
|
Initial index value for an automatic indexation.
|
|
Indicate whether to use first columns as indices.
|
|
Number of lines affected by the last SQL command.
|
|
Number of lines transferred during the last SQL command.
|
|
Indicate whether the last SQL command succeeded.
|
|
Length of the largest string that has been truncated.
|
|
Enable/disable message printing by OCI.
|
All parameters can be accessed with the Mosel function getparam, and those that are not marked read-only in the list below may be set using the procedure setparam.
Example:
setparam("OCIverbose", true) ! Enable message printing by OCI csize:=getparam("OCIcolsize") ! Get the maximum string length setparam("OCIconnection", 3) ! Select the connection number 3