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.
|
Properties
Name | Description | |
---|---|---|
MaxArrayLength |
Returns/Sets the maximum number of elements for return array parameters.
The total maximum size in bytes is 16,777,216.
| |
MaxNonStringSize |
Returns/Sets the maximum size for non-string return parameters.
| |
MaxStringElementSize |
Returns/Sets the maximum size of return string elements in array parameters.
| |
MaxStringSize |
Returns/Sets the maximum size of return string parameters.
|