Library: Database access (OMDB legacy) 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 Topics db.field db.database db.compile-statement db.discard db.statement db.streaming-execute

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 dbRecordMoveDynamic dbRecordSetMove dbRollback dbSetTransactionType dbStatement dbStatementCompile dbStatementDiscard dbStatementExecute dbStatementStreamingExecute dbTable dbTableClose dbTableDelete dbTableInsert dbTableOpen dbTableUpdate

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