Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle.jbo.DMLException JBO-26080

Oracle ITselfMay 9 2010 — edited May 11 2010

Dear All
i have a Updatable View with this query

SELECT EmployeeEO.EMP_ID,
EmployeeEO.EMP_NAME,
EmployeeEO.COUNTRY_CODE,
(select country_name from country where country_code = EmployeeEO.country_code) AS COUNTRYNAME,
EmployeeEO.AGE,
EmployeeEO.HIRE_DATE,
EmployeeEO.POSITION_CODE,
EmployeeEO.ACTIVE
FROM EMPLOYEE EmployeeEO

i can do insert and query is very good, but when i am trying query for any emp then update any attribute, i am getting this error
Please Note : i added country_name attribute to EmployeeEO Object to some validation issues

*(oracle.jbo.DMLException) JBO-26080: Error while selecting entity for EmployeeEO*
----- Level 1: Detail 0 -----
*(java.sql.SQLSyntaxErrorException) ORA-00936: missing expression*

Please Advise

Edited by: ORA ORA on May 9, 2010 7:04 AM

Edited by: ORA ORA on May 9, 2010 7:04 AM

Edited by: ORA ORA on May 9, 2010 9:50 AM

Edited by: ORA ORA on May 9, 2010 9:53 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2010

Added on May 9 2010

#application-development-in-java, #jdeveloper-and-adf

7 comments

1,891 views