| OraDatabase.Parameters - Suggestions [message #101388] |
Wed, 08 September 2004 23:55 |
Neolle
Messages: 2
Registered: September 2004
|
Junior Member |
|
|
Hello Guys,
I use OO4O in Visual Basic, and PL/SQL scripts.
Everytime I declare a Parameter I use
With OraDatabase
.Parameters.Add "HANDLE",vValue,ORAPARM_INPUT
.Parameters("HANDLE").ServerType = ORATYPE_VARCHAR2
'Do some .ExecuteSQL Stuff
.Parameters.Remove "HANDLE"
End With
Ok This is fine. But what if I place this inside a loop that is executed for say.. 1000 times. It's slow right? What I would like to do is that I want to declare
.Parameters.Add "HANDLE",vValue,ORAPARM_INPUT
.Parameters("HANDLE").ServerType = ORATYPE_VARCHAR2
only once, before the loop and
.Parameters.Remove "HANDLE"
only once too. After the loop.
My problem is that vValue changes its value within the loop.
Do you have any better ideas how to address this? Is there a OraDatabase.EditParameters or someting?
Thanks...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
