I am working on a project where I am using llbgen to rpelace a ugly stored proc that was wrriten
however i have an error that is throwing up
ORA-00936: missing expression
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OracleClient.OracleException: ORA-00936: missing expression
Source Error:
Line 372: mysickline.WebDate = Convert.ToDateTime(System.DateTime.Now())
Line 373:
Line 374: mysickline.Save()
Line 375:
Line 376:
here is my save code
mysickline.IsNew = True
mysickline.PersonalId = userId
mysickline.SickleaveType = leave
mysickline.StartDate = start
mysickline.EndDate = endDt
mysickline.Reason = reasonStr
mysickline.SubmittedBy = subBy
mysickline.Comments = comms
mysickline.AuthUser = ntid()
If leave <> "LTS" Then
mysickline.LtsMoveDate = lts
End If
mysickline.LastModified = Convert.ToDatdeTime(System.DateTime.Now())
mysickline.LastModifiedBy = ntid()
mysickline.WebDate = Convert.ToDateTime(System.DateTime.Now())
mysickline.Save()
i cant for the life of me see whats wrong I have used sql for years oracle confusing me a bit i have declared the pk and the identy seed in the entity designer i am at a loss
