Library: Oracle Call Interface database support (OMOCI legacy) Include: omoci.xin

Return type: Integer Returns: OCI_SUCCESS if the function completes without error.

Declaration

define external integer function OCI_oopt
   (  value OCI_Handle_type cursor,
      value integer rbopt,
      value integer waitopt
   )

This function sets rollback options for non-fatal Oracle errors involving multi-row "insert" and "update sql" statements. It also sets wait options (for example, whether to wait for locks) in cases where requested resources are not available.

Input arguments:

• cursor -- Cursor data area descriptor.
• rbopt -- The action to be taken when a non-fatal Oracle error occurs. The following values are allowed:
  • OCI_ROLLBACK_TRANSACTION -- All errors cause the current transaction to be rolled back.
  • OCI_ROLLBACK_ROW -- The failing row will be rolled back on non-fatal row-level errors. This is the default.
• waitopt -- Action to perform when resources are unavailable. The following values are allowed:
  • OCI_WAIT -- Wait indefinitely if resources are not available. This is the default.
  • OCI_NOWAIT -- Produce an error code if a resource is requested but unavailable

Example:

  set RetCode to OCI_oopt( Cursor, OCI_ROLLBACK_ROW, OCI_NOWAIT )

Other Library Functions OCI_Array_type OCI_GetArrayAsCounter OCI_GetArrayAsCounterShelf OCI_GetArrayAsStream OCI_GetArrayAsStreamShelf OCI_GetArrayAsString OCI_GetArrayElementCount OCI_GetArrayElementLen OCI_GetErrorCode OCI_Handle_type OCI_HostData_type OCI_IsVersionCompatible OCI_LibraryVersion OCI_obindps OCI_obndra OCI_obndrn OCI_obndrv OCI_ocan OCI_oclose OCI_ocof OCI_ocom OCI_ocon OCI_odefin OCI_odefinps OCI_odescr OCI_odessp OCI_oerhms OCI_oexec OCI_oexfet OCI_oexn OCI_ofen OCI_ofetch OCI_oflng OCI_ogetpi OCI_olog OCI_ologof OCI_onbclr OCI_onbset OCI_onbtst OCI_oopen OCI_oopt OCI_oparse OCI_orol OCI_osetpi OCI_SetArrayAsCounter OCI_SetArrayAsCounterShelf OCI_SetArrayAsStream OCI_SetArrayAsStreamShelf OCI_SetArrayAsString OCI_SetArraySize

[ INDEX ] [ CONCEPTS ] [ TASKS ] [ SYNTAX ] [ LIBRARIES ] [ LEGACY LIBRARIES ] [ ERRORS ]