An OParamArray an object enables you to place array bind variables within a SQL or PL/SQL
statement. The simplest use would be in the SQL statement that executes an insert
statement:
insert into part_nos(partno) values(:PARTNO)
In this example :partno is a parameter. (In SQL syntax, a parameter name is
prefixed with a colon.) When the SQL statement is executed, the current value of
the parameter is substituted for :pvalue. Such a parameter can be used
wherever a literal value can be placed: values within update and insert statements and
values that are part of where clauses.
Parameters are also used to represent arguments in calls to stored procedures.
A stored procedure is a PL/SQL program that is stored in the Oracle database.
Parameters can be used both as input and as output variables. See the example
in ExecuteSQL for a sample of calling a stored procedure.
Parameters are managed as OParameter or OParamArray objects. OParameter/OParamArray objects are managed by way of an OParameterCollection that exists for every database object. You attach parameter objects to
databases by using the Add method of the OParameterCollection class. OParamArray is a subclass of OOracleObject.
The primary benefit of using OParamArray is efficiency and reduction of network traffic. For example using OParamArray objects, you can insert multiple rows at a time using a single "insert"
statement.
Parameters are attached to an ODatabase object. By default OParameters are
auto-enabled. This means that they can bind to any ODynasets and OSqlStmts. By
using the AutoEnable method, you can turn this default behavior off and on. This
can be useful if there are a large number of OParamArray objects, which
could result in many parameters being unnecessarily bound. Such a condition
does not cause errors, but might be inefficient.
See Also
AddTable MethodConstruction and destruction:
OParamArray~OParamArrayoperator=
Attributes:
GetNameGetServerTypeGetStatusOperations: