Control parameters
The following parameters are defined by mmoci:
| OCIautocommit |
Enable/disable "commit on success" in OCI.
|
| OCIautondx |
Enable automatic indexation of arrays.
|
| OCIbufsize |
Data buffer size.
|
| OCIcolsize |
Maximum string length.
|
| OCIconnection |
Identification number of the active OCI connection.
|
| OCIdebug |
Enable/disable debug mode.
|
| OCIfirstndx |
Initial index value for an automatic indexation.
|
| OCIndxcol |
Indicate whether to use first columns as indices.
|
| OCIrowcnt |
Number of lines affected by the last SQL command.
|
| OCIrowxfr |
Number of lines transferred during the last SQL command.
|
| OCIsuccess |
Indicate whether the last SQL command succeeded.
|
| OCItruncsize |
Length of the largest string that has been truncated.
|
| OCIverbose |
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