Library: Database access (OMDB) legacy library Include: omdb.xin

Declaration

  define external function dbStatementExecute
           value       dbStatement statement
     with  read-only   stream      values    optional
     null  value       stream      null      optional
   record  modifiable  dbField     record    optional

Argument definitions

statement

is a compiled dbStatement object.

values

is a shelf containing the parameter data.

null

is an optional string representing null values.

record

is a shelf of dbField items bound to result set fields.

Use dbStatementExecute to execute a compiled SQL statement that was produced by the dbStatementCompile function.

Requirements

You must include the following line at the beginning of your OmniMark program:

  include "omdb.xin"

The dbDatabase object supplied when the statement was compiled must be open (else external exception OMDB101).

The dbStatement object statement must be open (else external exception OMDB701).

If the dbStatement object is a compiled query, it requires the dbField shelf argument record to receive the results (else external exception OMDB704).

The input shelf values must:

• contain the parameters required by the compiled statement (else external exception OMDB702).
• contain the correct number of parameters (else external exception OMDB703).
• contain the correct size of parameters (else external exception OMDB704).

Usage Notes

dbStatementExecute allows you to execute a compiled statement and to specify all the parameter values at once. This is more efficient for small parameters.

For large parameters (for example, DB_BLOB types) when there is a large amount of data to be inserted, it is more efficient to use the dbStatementStreamingExecute function, as that avoids creating an entire copy of the data in memory prior to execution.

See dbStatementCompile for additional notes and examples.

Related Syntax    db.field    db.database    db.compile-statement    db.discard    db.statement    db.streaming-execute

Related Concepts    Using the OMDB library

Other Library Functions    dbClose    dbCommit    dbDatabase    dbExecute    dbField    dbFieldPrepare    dbFieldSink    dbFieldValue    dbIsVersionCompatible    dbLibraryVersion    dbLibraryVersionOCI8    dbLibraryVersionOCI8i    dbLibraryVersionODBC    dbOpenOCI8    dbOpenOCI8i    dbOpenODBC    dbProcedure    dbProcedureClose    dbProcedureExecute    dbProcedureOpen    dbQuery    dbRecordExists    dbRecordMove    dbRecordSetMove    dbRollback    dbSetTransactionType    dbStatement    dbStatementCompile    dbStatementDiscard    dbStatementExecute    dbStatementStreamingExecute    dbTable    dbTableClose    dbTableDelete    dbTableInsert    dbTableOpen    dbTableUpdate

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