CODEWITHSUNDEEP
oracle-apex
Eslam
Eslam

Reputation: 363

Failed to parse SQL query - column invalid identifier

I am on Application Express 21.1.0.

I added a column to a db table, and tried to add that column to the Form region based on that table.

I got error...

ORA-20999: Failed to parse SQL query! ORA-06550: line 4, column 15: ORA-00904: "NEEDED_EXAMS": invalid identifier And I can not find the column in any "source> column" attribute of any page item of that form.

I can query the new column in "SQL COMMANDS".

The new column's name is "NEEDED_EXAMS". It's a varachar2(500).

Upvotes: 0

Views: 545

Answers (2)

Eslam
Eslam

Reputation: 363

Solved. I have many parsing schemas. And I was creating tables through object browser in different schema than my app's parsing schema.

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 142713

Don't do it manually; use built-in feature by right-clicking the region and then select "Synchronize columns" from the menu as it'll do everything for you. It works for reports and forms.

enter image description here

Upvotes: 0

Related Questions