Oracle Database Discussions

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!

Access Queries with "IIF" function

272574Mar 24 2006 — edited Mar 27 2006

We have several queries using the "IIF" function in Access 2000. When we try to build the Oracle model an eror is generated:
Error occured on line 1:
oracle.mtg.msaccess.parser.queryparser.ParseException: Parse error at line 1, column 232. Encountered: (

The column number seems to be spurious as is the character reported "(" sometimes we also get "OR", "AND" etc.. However I have traced it to where an "IIF" function is used.

Does anyone know if this is supported, or if there is any way that I can force the Oracle object to be created in the Oracle model so that I can manually re-engineer it.

Thanks

Kevin

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2006

Added on Mar 24 2006

#database-and-application-migrations

5 comments

10,439 views