Skip to Main Content
Forums

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!

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation in ADF

Sahdeep RajputDec 9 2014 — edited Dec 10 2014

ViewBindVariable.jpgHi Guys,

I am getting exception by executing the view object programatically. I have view object with one bind variable......Error Like

Coding Part Like :

| | ViewObjectImpl allnzInstCustDtlsViewImpl = getAllnzInstCustDtlsView1(); |
| | allnzInstCustDtlsViewImpl.clearCache(); |
| | allnzInstCustDtlsViewImpl.setNamedWhereClauseParam("icustid", CustId); |
| | allnzInstCustDtlsViewImpl.executeQuery(); |
| | allnzInstCustDtlsViewRow = allnzInstCustDtlsViewImpl.first(); |

After executing the code I am getting below error : where AllnzInstCustDtls.CUST_ID is a primary key...

|

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement:

SELECT AllnzInstCustDtls.INST_NAME,

AllnzInstCustDtls.SHORT_NAME,

AllnzInstCustDtls.INDUSTRY_CLASS,

AllnzInstCustDtls.ADDR_LINE1,

AllnzInstCustDtls.MESSENGER1,

AllnzInstCustDtls.MESSENGER2,

AllnzInstCustDtls.MESSENGER3,

AllnzInstCustDtls.TYPE1,

AllnzInstCustDtls.TYPE2,

AllnzInstCustDtls.TYPE3,

AllnzInstCustDtls.STREET_NAME

FROM ALLNZ_INST_CUST_DTLS AllnzInstCustDtls WHERE AllnzInstCustDtls.CUST_ID = ViewObject1.jpg:icustid

|
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2015
Added on Dec 9 2014
#application-development-in-java, #jdeveloper-and-adf
5 comments
3,498 views