Parameter Bindings

OO4O provides a way of enabling and disabling Parameter object binding at the time it processes the SQL statement. This can be done through AutoBindDisable and AutoBindEnable methods of the OraParameter object. If the SQL statement does not contain the parameter name, it is better to disable the OraParameter because it avoids an unnecessary reference of the parameter object. This is especially effective when the application is written primarily using PL/SQL procedures. For example:

Set OraDatabase = OraSession. OpenDatabase("ExampleDb",

"scott/tiger", 0&)

'Add the job input parameter with initial value MANAGER.

OraDatabase.Parameters.Add "job", "MANAGER", 1

'Add the deptno input parameter with initial value 10.

OraDatabase.Parameters.Add "deptno", 10, 1

'Add the job input parameter with initial value MANAGER.

OraDatabase.Parameters.Add "EmpCur", 0, 1

OraDatabase.Parameters("Empcur").ServerType = ORATYPE_CURSOR

'Disable the job parameter for now.

OraDatabase.Parameters("job").AutoBindDisable

set OraSqlStmt = CreateSQL.CreateSQL("Begin GetEmpData(:Empcur, :deptno)

End;",0&)

Note how the "job" parameter object is not referenced while processing PL/SQL statement.