Skip to Main Content
This is a BETA environment
This environment is only for testing and may be reset multiple times during the testing period. We will be frequently upgrading this BETA environment, so check back often for changes. Please assist us by providing feedback via the bug icon to the left of your profile avatar. For the current active community, visit

VO Expert Mode and DAC

282109Nov 19 2000

I had posted a similar query earlier - but I couldnot get enough advise on this.

If I do the following in VO expert mode:

1. Write a simple query like
select * from EMP

2. In the Attribute Settings select all the fields as not mapped (i.e., not updatable)

When I create a RowsetInfo for this VO,I get an error dialog:
"Invalid Query Definition
ORA-00928 missing SELECT keyword"

I am using JDeveloper 3.0.Do let me know, if this is a bug and has been rectified in the next versions.

Also, it would be helpful, if you could let me know, how I could solve this error in Version 3.0


Post Details
Added on Nov 19 2000