SqlOra
Namespace: PPJ.Runtime.Sql
Assembly: PPJ.Web.49 (4.9.0.0)
Oracle specific functions implementation.
- C#
- VB.NET
public class SqlOra
Public Class SqlOra
Properties
MaxArrayLength
Int32: Returns/Sets the maximum number of elements for return array parameters. The total maximum size in bytes is 16,777,216.
MaxNonStringSize
Int32: Returns/Sets the maximum size for non-string return parameters.
MaxStringElementSize
Int32: Returns/Sets the maximum size of return string elements in array parameters.
MaxStringSize
Int32: Returns/Sets the maximum size of return string parameters.
Methods
PLSQLCommand(hSql, command)
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.
| Parameter | Type | Description |
|---|---|---|
| hSql | SalSqlHandle | |
| command | String |
Returns: Boolean.
PLSQLExecute(hSql)
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.
| Parameter | Type | Description |
|---|---|---|
| hSql | SalSqlHandle | The sql handle associated with the prepared Anonymous PL/SQL block. |
Returns: Boolean. Boolean
PLSQLPrepare(hSql, plsql)
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.
| Parameter | Type | Description |
|---|---|---|
| hSql | SalSqlHandle | A handle that identifies a database connection. |
| plsql | String | The actual anonymous PL/SQL block that the user wants to prepare. That will also contain the input and output variables. |
Returns: Boolean. bOk