I'm binding parameters using Managed Provider for Oracle & get the following
error. If I don't use parameter, the stmt works fine. But I need to bind the
parameters. Any suggestions?

System.Data.OracleClient.OracleException: ORA-01036: illegal variable
name/number at
System.Data.OracleClient.OracleConnection.CheckError(OciHandle errorHandle,
Int32 rc) at System.Data.OracleClient.OracleParameterBinding.Bind(OciHandle
statementHandle, NativeBuffer parameterBuffer, OracleConnection connection)
at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle,
CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle&
rowidDescriptor, ArrayList& refCursorParameterOrdinals) at
System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle,
CommandBehavior behavior, ArrayList& refCursorParameterOrdinals) at
System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior
behavior) at ConnPool.WebForm1.GetUserInfo() in C:\Documents and
Settings\smalathi\VSWebCache\webdev\ConnPool\WebForm1.aspx.vb:line 58
            SQL = "select * from users where username = ?"
            ConnOra = New OracleConnection(ConnectStr)
            ConnOra.Open()
            cmdOra = New OracleCommand(SQL, ConnOra)
            cmdOra.CommandType = CommandType.Text
            ParamOra = New OracleParameter("username", OracleType.VarChar,
10)
            ParamOra.Direction = ParameterDirection.Input
            ParamOra.Value = NTUserName
            cmdOra.Parameters.Add(ParamOra)
            rdrOra 
cmdOra.ExecuteReader(CommandBehavior.Default) ------------- line # 58



Regards,
S.Malathi, IT Project Analyst
ADNOC Distribution
P.O. 4188, Abu Dhabi
Tel : 6959480 (D)
Mob : 050 5316055
Fax : 6742265



DISCLAIMER:
-------------------------------------------------------------------------------------------------------------
 Please note that our domain name is changed from adnoc-fod.co.ae to adnoc-dist.co.ae
 Hence change your email addresses accordingly to reflect these changes.
 This communication may contain confidential information.  If you are not the intended recipient 
 please inform us immediately.
 For complete disclaimer note please visit our website at:
 http://www.adnoc-dist.co.ae/emaildisclaimer.htm
                                                                                                                             
 Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
 Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae