problem in executing oracle procedure with parameters

[nasim...@gmail.com]

I am working with rdo in vb6.0 and trying to call a stored procedure in
oracle 10g express edition . when i am passing direct values through
procedure it works fine, but when i try to pass a value or return a
value from procedure using variables, it shows an error ::could not
find the item indicated by text.on stm || qd(0)="text"

sample code::

Dim qd As New rdoQuery
Dim qsql As String

qsql = "{call get(?,?,?)}"
Set qd = cn.CreateQuery(" ", qsql)
qd(0)="text"
qd(1)="textkey"
qd.execute
Msgbox "value" & qd(2)

If any one can help it will be great help
thanking you!
Nasim ahmed

[Henning]

<nasim...@gmail.com> skrev i meddelandet
news:1164380372.7...@k70g2000cwa.googlegroups.com...

try setup parameter type and direction first.

qd(0).Type = rdTypeVARCHAR 'or CHAR
qd(0).Direction = rdParamInput
qd(1).Type =
qd(1).Direction = rdParamInput
qd(2).Type =
qd(2).Direction = rdParamOutput
qd.rdoParameters(0).Value =
qd.rdoParameters(1).Value =

/Henning