Hi all,

I have an application where I am trying to access an Oracle stored

procedure.

I get this runtime error message:


Runtime error '40041':

Object Collection: Couldn't find item indicated by text.


Here is a part of my code:

'

Dim qryCheckBatch As New rdoQuery

Dim rsCheckBatch As rdoResultset


Set qryCheckBatch = Cn.CreateQuery("CheckBatch", "{ ? = Call

dps_point_of_sale.is_batch_summarized (?) }")

Error -->qryCheckBatch(0).Direction = rdParamReturnValue

qryCheckBatch(1) = Val(lblBackoutBatchID.Caption)

Set rsCheckBatch = qryCheckBatch.OpenResultset(rdOpenForwardOnly,

rdConcurReadOnly)

'

Cn is defined in SubMain() as public rdoConnection.


The surprising part is that this exact code worked for me earlier without

any problems. My friend was trying to do a similar thing and he used to get

this error. I had recently upgraded to VB 6.0 and I got this error. I

installed 5.0 again, but now I am stuck with this error.


Did anyone have this problem or knows a solution or alternate method /

workaround?

Any help will be highly appreciated, thanks!


Hiten