Using bind variables with VB and ADO but viewing SQL_AREA shows non-bound parameters

From: gary gibbons <aalegrias_at_yahoo.com>
Date: 7 May 2003 15:22:49 -0700
Message-ID: <900c6d6a.0305071422.255f07d5@posting.google.com>

I am using VB components to access ORACLE 8.7

I am using the parameter syntax for paramter passing with ADO:

   Set mySelectCmd = New ADODB.command     

    mySelectCmd.activeConnection = myConn
    mySelectCmd.CommandType = adCmdText
    mySelectCmd.CommandText = "select username from member where

memberid = ?"

    mySelectCmd.Parameters.Append
mySelectCmd.CreateParameter("userId", adInteger, adParamInput, , userId)

    Set myRSReturn = mySelectCmd.Execute

The Select works, but viewing the SQL_AREA table on the oracle DB, I see no indication of bind variables being used. Rather than seeing the ":varname" format, I see a SQL entry for each unique value, and this is not Oracle binding behavior.

It seems to me that ADO is not really binding the values at all.

ANy ideas how to solve this?

gary gibbons
aalegrias_at_yahoo.com Received on Wed May 07 2003 - 17:22:49 CDT