oracle objects for OLE 1

[Ravala]

I use OraParameter object supporting PL/SQL cursor.
When I create ora parameter if there is way to know in advance that parameter exists.
I code:
MyDatabase.Parameters.Add "NAME", "JOCKSPORTS", ORAPARM_INPUT
MyDatabase.Parameters("NAME").ServerType = ORATYPE_VARCHAR2
some code ....
MyDatabase.Parameters.Remove ("NAME")

Still sometimes I have error: duplicate parameter name.

Thanks.

 

[vladk]

Ravala

Each time before you want to add parameters just run code like this:

For i = MyDatabase.Parameters.Count To 0 Step -1
MyDatabase.Parameters.Remove (i)
Next i

vladk