2 Replies Latest reply on Sep 25, 2015 4:26 AM by michalkraus87

    ORA-01461:can bind a LONG value only for insert into a LONG Column

    neil_p1000 Apprentice

      Any Ideas why we would get this error when typing into a unlimited string field

       

       

      Error

      There has been an unexpected error. Click Continue to return to the previous page.

      ORA-01461: can bind a LONG value only for insert into a LONG column

      at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
      at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
      at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
      at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
      at Touchpaper.Framework.Data.Pm.Rdb.RdbTransaction.ExecuteCommand(RdbCommand cmd)
      at Touchpaper.Framework.Data.Pm.Rdb.RdbTransaction.ExecuteCommand(RdbCommand cmd, IList listExtraCommands, Boolean getIdentity)
      at Touchpaper.Framework.Data.Pm.Rdb.RdbTransaction.UpdateObject(IDataObjectInternal dataObject)
      at Touchpaper.Framework.Data.DataObjectContext.UpdateObject(DataObject dataObjectDirty)
      at Touchpaper.Framework.Data.DataObjectContext.DoUpdates(IList listToUpdate, IList listMutualDependencies)
      at Touchpaper.Framework.Data.DataObjectContext.SaveChanges()
      at Touchpaper.Web.Console.Controllers.ObjectController.SaveInternal(ObjectParameters parameters, Func`3 getObject)
      at Touchpaper.Web.Console.Controllers.ObjectController.Save()
      at lambda_method(Closure , ControllerBase , Object[] )
      at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
      at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.b__a()
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
      at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)