The SqlOra type exposes the following members.
Methods
Name | Description | |
---|---|---|
PLSQLCommand |
Executes an Oracle PL/SQL stored procedure. The first parameter identifies the SQL handle to the database.
The second parameter is a command string used to invoke a PL/SQL stored procedure.
For some strange reason, PLSQLCommand bind vars don't use the colon delimiter, so we need
to parse the bind vars, add the delimiter and reassemble the string.
| |
PLSQLExecute |
This function executes the anonymous PL/SQL block that was prepared
using SqlOraPLSQLPrepare. If the execution succeeds, then all output
parameters from the PL/SQL block are updated by the time the control
returns to the user.
| |
PLSQLPrepare |
This function compiles the anonymous PL/SQL block. This function looks very much
like the regular SqlPrepare function, but the underlying code is meant specifically
for handling Oracle PL/SQL blocks.
|