This discussion is archived
2 Replies Latest reply: Apr 11, 2013 6:11 AM by user8058501 RSS

Getting errors when updating a column on a table having a primary key

user8058501 Newbie
Currently Being Moderated
Hi,

I have an application on Oracle APEX that raises the following error after an attempt (through the application) to update a column with no specific constraint on it:

ORA-06550: line 1, column 17: PL/SQL: ORA-00936: missing expression ORA-06550: line 1, column 9: PL/SQL: SQL Statement ignoredUnable to fetch row.

The involved table has a primary key conatraint and the corresponding column can be populated by a sequence (but there is no trigger to manipulate the sequence).
The sequence is mentioned in the involved page definition for populating the primary key.

If I disable the primry key and set to null the corresponding value for the primary of the record to be updated, then it is possible to update that record (thus the above column) through the application.

Did someone encountered this situation before?
If yes, what was then your workaround/solution?

Kind Regards.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points