Got ora-00001 but insert completed sucessfully
When users tried to save (insert) the values in Forms application, got this error message ORA-00001. But when DBA checked the table , found that the values have been saved (inserted) successfully in the database.
And meanwhile the forms fields for inserting/saving the values were still blank which meant there were not values retrieved by execute_query to display in the forms even the values have been existing in the table.
any suggestion or idea about this is appreciated.