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

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

Declaration

define external integer function OCI_oparse
   (  value OCI_Handle_type cursor,
      value string sqlstm,
      value integer sqllen,
      value integer defflg,
      value integer lngflg
   )

This function parses an SQL statement or a PL/SQL block and associates it with a cursor. The parse can, optionally, be deferred.

Input arguments:

• cursor -- Cursor data area descriptor.
• sqlstm -- The SQL statement.
• sqllen -- The length of the contents of sqlstm or OCI_NTS.
• defflg -- Deferred parsing flag. The following values are allowed:
  • OCI_DEFERRED -- Defer the parse of the SQL statement until execution. This is the preferred method.
  • OCI_NODEFERRED -- Parse the SQL statement immediately.
• lngflg -- ANSI conformance flag. The following values are allowed:
  • OCI_ORACLE_V6 -- Specifies Oracle Version 6 behavior.
  • OCI_ORACLE_V7 -- Specifies Oracle Version 7 behavior.
  • OCI_ORACLE_DEFAULT -- Specifies behavior dependent on the connected database.

Example:

  set RetCode to OCI_oparse
     (  Cursor,
        "insert into Midi values ( 4, :Midi )",
        OCI_NTS,
        OCI_NODEFERRED,
        OCI_ORACLE_V7
     )

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 ]