The SqlOra type exposes the following members.

Methods

  NameDescription
Public methodStatic memberPLSQLCommand
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.
Public methodStatic memberPLSQLExecute
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.
Public methodStatic memberPLSQLPrepare
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.

See Also