急等！为什么使用OracleParameter 设置参数OracleDataAdapter 会出现异常

Question

代码如下:
public static DataSet GetShangJiaLogin(UserInfoShangJia UserInfo)
    {
        //获取连接字符串
        string ConnStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        ////创建并设置OracleConnection
        OracleConnection dbConn = new OracleConnection(ConnStr);
        //创建并设置OracleCommand
        OracleCommand dbCmd = new OracleCommand();
        //dbCmd.Connection.
        //dbCmd.Connection = dbConn;
        dbCmd.Connection = dbConn;
        dbCmd.CommandType = CommandType.Text;
        dbCmd.CommandText = "Select * from USERINFOSHANGJIA where UserName = @UserName and UserPassword = @UserPassword";
        
        //设置OralceParameter
        OracleParameter dbParameter_Username = new OracleParameter();
        dbParameter_Username.ParameterName = "@UserName";
        dbParameter_Username.Value = UserInfo.UserName;
        dbParameter_Username.DbType = DbType.String;
        //向OracleCommand中添加OralceParameter
        dbCmd.Parameters.Add(dbParameter_Username);        OracleParameter dbParameter_UserPassword = new OracleParameter();
        dbParameter_UserPassword.ParameterName = "@UserPassword";
        dbParameter_UserPassword.Value = UserInfo.UserPassword;
        dbParameter_UserPassword.DbType = DbType.String;
        dbCmd.Parameters.Add(dbParameter_UserPassword);
        
        //创建OracleDataAdapter,并获取数据
        //OracleDataAdapter DataAdapter = new OracleDataAdapter("Select * from USERINFOSHANGJIA where UserName = '"+ UserInfo.UserName +"' and UserPassword = '"+ UserInfo.UserPassword +"'",dbConn);
        OracleDataAdapter DataAdapter = new OracleDataAdapter(dbCmd);
        DataSet Ds = new DataSet();
        DataAdapter.Fill(Ds);
        //返回数据
        return Ds;
    } DataAdapter.Fill(Ds);这句话出现异常！

Answer 1

用户代码未处理 System.Data.OracleClient.OracleException
  Message="ORA-01036: �Ƿ��ı䁿û/�຅\n"
  Source="System.Data.OracleClient"
  ErrorCode=-2146232008
  Code=1036
  StackTrace:
       在 System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       在 System.Data.OracleClient.OracleParameterBinding.Bind(OciStatementHandle statementHandle, NativeBuffer parameterBuffer, OracleConnection connection, Boolean& mustRelease, SafeHandle& handleToBind)
       在 System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       在 System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
       在 System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
       在 System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
       在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       在 UserInfoShangJiaDB.GetShangJiaLogin(UserInfoShangJia UserInfo) 位置 d:\Web\FM315\App_Code\UserInfo\UserInfoShangJia\UserInfoShangJiaDB.cs:行号 51
       在 UserInfoShangJiaComponent.GetUserInfoShangJiaLogin(UserInfoShangJia UserInfo) 位置 d:\Web\FM315\App_Code\UserInfo\UserInfoShangJia\UserInfoShangJiaComponent.cs:行号 21
       在 UserLogin_ShangJiaLogin.BtnLogin_Click(Object sender, EventArgs e) 位置 d:\Web\FM315\UserLogin\ShangJiaLogin.aspx.cs:行号 25
       在 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       在 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       在 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       在 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       在 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Answer 2

dbParameter_Username.DbType = DbType.String;
//这个地方的第二个DbType是不是需要换成OraclDbType的某种类型阿