Wednesday, 3 June 2015

OAF: Issues associated with VO Substitution in Oracle Applications Framework - Part2

In this post I will explain the fix for some other issues associated with VO Substitution in Oracle Application Framework.

This is the continuation of my other blogs on the VO Substitution issues:
OAF: Issues associated with VO Substitution in Oracle Applications Framework - Part1
OAF: Transient Attributes not getting populated in Extended VO


Sample errors:
## Detail 0 ## java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: INVOICE_ID

## Detail 0 ## java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Reference of errors :
https://community.oracle.com/thread/3729150
https://community.oracle.com/thread/3727660


Fix:
Change the Binding Style of VO from 'Oracle Named' to 'Oracle Positional'.


Refer the below link for more details about the Named and Positional bindings.
Binding and Defining


Feel free to point out if anything is missing/wrong in this blog.

2 comments:

  1. This Worked Perfect for me. same error
    By changing Binding Style of VO from 'Oracle Named' to 'Oracle Positional'.resolved error.
    Thanks

    ReplyDelete