Full text search
function	OCI_oparse

Library: OCI Include: omoci.xin

Returns: Numeric Returns OCI_SUCCESS if the function completes without error.

Declaration

  define external counter function OCI_oparse
     (  value OCI_Handle_type cursor,
        value stream sqlstm,
        value counter sqllen,
        value counter defflg,
        value counter 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 dependant on the connected database.

Example: