asp.net+oracle问题:系统提示错误“ORA-01036: 非法的变量名/编号 ”
代码如下:
OracleConnection conn = new OracleConnection(connectionString);
OracleCommand cmd = new OracleCommand( "INSERT INTO " + tableName + " " +
" (PKID, Username, OraclePassword, Email, PasswordQuestion, " +
" PasswordAnswer, IsApproved, " +
" OracleComment, CreationDate, LastPasswordChangedDate, LastActivityDate, " +
" ApplicationName, IsLockedOut, LastLockedOutDate, " +
" FailedPWDAttemptCount, FailedPWDAttemptWindowStart, " +
" FailedPWDAnswerAttemptCount, FailedPWDAnswerAttemptWinStart) " +
" Values(:OPKID, :OUsername, :OOraclePassword, :OEmail, :OPasswordQuestion, :OPasswordAnswer, :OIsApproved, :OOracleComment, " +
":OCreationDate, :OLastPasswordChangedDate, :OLastActivityDate, :OApplicationName, :OIsLockedOut, :OLastLockedOutDate, " +
":OFailedPWDAttemptCount, :OFailedPWDAttemptWindowStart, :OFailedPWDAnswerAttemptCount, :OFailedPWDAnswerAttemptWinStart) ", conn);
cmd.Parameters.Add( "OPKID ", OracleType.VarChar,255).Value = providerUserKey.ToString();
cmd.Parameters.Add( "OUsername ", OracleType.VarChar, 255).Value = username;
cmd.Parameters.Add( "OOraclePassword ", OracleType.VarChar,