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!

VO - bind variable in where clause problem

RobalJan 22 2014 — edited Jan 27 2014

I have Jdeveloper 12. I successfully connected to mySQL database which works in Oracle mode (PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, NO_AUTO_CREATE_USER)

Next I created EO, VO (screenshot) and finally AM.

when I run Application Module and enter bind variable value I receive error (screenshot):

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EO_TMP.create_date, EO_TMP.id, EO_TMP.name FROM autoid.advert EO_TMP WHERE EO_TMP.id = :var1

## Detail 0 ##

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

Doesn anybody know hot to fix this issue?

Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2014

Added on Jan 22 2014

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

9 comments

984 views