Home » Infrastructure » Windows » OraDatabase.Parameters - Suggestions
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...

 

 
Previous Topic: Usage of 4GT on Win2k
Next Topic: ADO Connection to Oracle, URGENT HELP NEEDED PLEASE!
Goto Forum:
  


Current Time: Fri May 27 01:20:53 CDT 2022