Comments by Sheikh Waqas Ali (Top 5 by date)

Oracle.DataAccess.Client.OracleException ORA-06550: line 1, column 7: PLS-00221: 'AUTHENTICATEUSER' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at SchoolsManagementSystem.DAL.AunthicateUser(String username, String password) in d:\c#\SchoolsManagementSystem\SchoolsManagementSystem\App_Code\DAL.cs:line 48 at SchoolsManagementSystem.Login.btnLogin_Click(Object sender, EventArgs e) in d:\c#\SchoolsManagementSystem\SchoolsManagementSystem\Login.aspx.cs:line 45


Above error show

Not working



public int AunthicateUser(string username, string password)
{
using (OracleConnection con = GetConnection())
{
// OracleCommand cmd = new OracleCommand("SELECT * FROM AuthenticateUser(@UserName, @Password)", con);

// cmd.Parameters.Add("@UserName", "username");
// cmd.Parameters.Add("@Password", "password");


// OracleDataAdapter da = new OracleDataAdapter(cmd);

// DataTable dt = new DataTable();
//da.Fill(dt);

//string str = dt.Rows[0][0].ToString();
// Response.Write(str.ToString());


OracleCommand cmd = new OracleCommand("AuthenticateUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserName", username);
cmd.Parameters.Add("@Password", password);


con.Open();
int result = (int)cmd.ExecuteNonQuery();

return result;
}
}

Oracle.DataAccess.dll
oraociicus11.dll
OraOps11w.dll
orannzsbb11.dll
oraocci11.dll
ociw32.dll

where is the location of above DLLs and guide me about c# Execute able folder

I have installed ODP.NET thruogh ODAC112040Xcopy_32bit and then click install.bat and configure.bat and then added following refrence of Oracle.DataAcess.dll in Visual studio
D:\tutorials\oracle\ODAC112040Xcopy_32bit\odp.net4\odp.net\bin\4 Oracle.DataAccess.dll

I also installed oracle client runtime

D:\app\hp\product\11.2.0\client_1\ODP.NET\bin\2.x Oracle.DataAccess
and in it also have Oracle.DataAcess which refrence I used in oracle client