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!

ViewCriteria Causing "Attempt to set a parameter name that does not occur in the SQL"

Ray KellyNov 7 2013 — edited Nov 7 2013

I have the following set up:

JDeveloepr 11.1.1.6

BC EO

VO (select col_a, col_b, col_c from table_a)

I added a bind variable (colAVariable) to the VO.

I added a ViewCriteria (colACriteria) to the VO (where col_a = colAVariable).

In the AppModule, I added an instance of the VO.

I editted the View Instance. I moved colACriteria to selected. I set the value of colAVariable to 2 (it's a Number field).

I saved all.

I refreshed my DataControls.

I dropped the View Instance on the page as a PanelForm.

I ran the page.

I get an error that states "Attempt to set a parameter name that does not occur in the SQL: 1"

I have no idea why it is looking for a parameter named '1'.

Am I doing something wrong?

Did I miss something?

Thanks,
Raymond

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2013

Added on Nov 7 2013

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

5 comments

730 views