Other Library Functions

function

dbProcedureExecute

Library: omdbext - extended high level database support Include: omdbext.xin

Declaration

  define external function dbProcedureExecute
                 value          dbProcedure     procedure
       in       read-only     stream      in      optional
       null     value          stream      null    optional
       out      modifiable   dbField     out     optional
       result    modifiable   dbField    result   optional

Where:
procedure

An open stored procedure.

A shelf of stream items that contain the input parameter values.

A string, rather than an unattached stream, to represent a NULL value in the input parameter values.

A shelf of dbField items to receive output and inout parameter values.

A dbField shelf attached to the procedure return value(s).

This function executes a stored procedure.

At the beginning of the function, the output shelf is cleared and filled with dbField items attached to the output and inout (combined input and output) procedure parameters. The input shelf items are sequentially matched to the procedure input parameters by position. You can represent NULL values in the input shelf item by an optional null specifier string or as an unattached stream.

The result shelf is cleared in the function. If the procedure returns a result value or record, the result shelf is filled with dbField items attached to the results. The data value is extracted from the output and return parameters in a subsequent call to the dbFieldValue function.

The output and result dbField field items are keyed with the name of the procedure parameter, if one exists.

Date and time fields