locked
ora-01036 illegal variable name/number Error RRS feed

  • Question

  • User-543160537 posted

    Hi,

    I am trying to insert data using stored procedure and i getting error (ora-01036 illegal variable name/number)..

    here is my code

    public void Add()
    {
    DAL.Database db = DAL.DatabaseFactory.CreateDatabase(Classes.Configuration.ProviderType, Classes.Configuration.ConnectionString);
    IDbConnection dbConn = db.GetConnection();
    dbConn.Open();
    DAL.DBCommandWrapper dbCmd;

    dbCmd = db.GetStoredProcCommandWrapper("PRAT_DBO.package.testprocedure ");

    dbCmd.AddInParameter("p_in_division", DbType.String, AddItem.exc_division);
    dbCmd.AddInParameter("p_in_subject", DbType.String, AddItem.exc_subject);
    dbCmd.AddInParameter("p_in_body ", DbType.String, AddItem.exc_body);

    dbCmd.Command.Connection = dbConn;
    db.ExecuteNonQuery(dbCmd);

    }

    Thursday, September 18, 2014 2:33 PM

Answers

All replies