CODEWITHSUNDEEP
oracle-databaseoracle11goracleforms
mark080
mark080

Reputation: 429

oracle forms not showing all fields

I have 2 tables: product which has primary key product_id and Review which has product_id which references the product_id of product table; I created form master-detail for them but when executing I get at the bottom of page:

FRM-40505: ORACLE error: unable to perform query

and when pressing ctrl+shift+e I get:

SELECT ROWID, REVIEW_ID, LIKE, DISLIKE, FIRST_NAME, LAST_NAME, PRODUCT_ID 
  FROM U1.REVIEW WHERE (PRODUCT_ID=:1)

ORA-00936: missing expression

how to solve this? what is wrong? thank you in advance

Upvotes: 5

Views: 2147

Answers (1)

Barbaros Özhan
Barbaros Özhan

Reputation: 65218

Seems you have a field named like in your block with base table named review has Database Item set to Yes in the property palette, and for this reason Oracle treats that field as if a column of the table, but there's no such column, and not possible to have a column named like within a db table, since it's a reserved keyword.

Upvotes: 5

Related Questions