Named Parameters in BC4J View Object Creation (Doc ID 306609.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle JDeveloper - Version: 9.0.5.1.0 to 10.1.2.4.0 - Release: AS10g to JDeveloper 10g
Information in this document applies to any platform.
***Checked for relevance on 09-Sep-2010***
Applications requiring named parameters to create BC4J objects.

Goal

This article describes current and upcoming techniques for using named and positional parameters in BC4J.
A naive implementation, using a named parameter query, results in errors:


oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. 
Statement: SELECT * FROM (select last_name, first_name from employees
where employee_id = :thisID  order by last_name, first_name) QRSLT  WHERE (employee_id = 203)
(...)
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms