bind variable

[Flokkie]

I'm using VBA to get a recordset from Oracle:

SQL = "SELECT * from 010_TABLE where custno = '" & var_custno & "' "
Set rsora = New ADODB.Recordset
rsora.LockType = adLockBatchOptimistic
rsora.CursorType = adOpenForwardOnly
rsora.CursorLocation = adUseClient
rsora.Open SQL, CnRasprd
Set frm = Formulier
Set Formulier.Recordset = rsora

Because the SQL-string is send to Oracle and is different every time
(var_custno)
the querie is parsed in Oracle every time. I want make use of bind variable
to avoid this. Can anybody help me????
Jan Jouke Flokstra