Named Parameters in BC4J View Object Creation
Last updated on AUGUST 04, 2016
Applies to:Oracle JDeveloper - Version: 22.214.171.124.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.
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
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