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.
|