ORA-01465:invalid hex number-while calling sql through hibernate:

Could you please provide me help to resolve this issue ASAP..

While executing the below sql query through Hibernate, it is giving

Quote:

ORA-01465:invalid hex number

error.
Please see below for the code and log message for clear idea.

Sql Query is

Code:

SELECT
        distinct        H.EMPL_PPNT_ID_NU AS emplPpntIdNu,
        H.EMPL_USER_ID AS emplUserId,
        H.EMPL_FST_NA AS empFirstName,
        H.EMPL_LAST_NA AS empLastName,
        L.LOC_NU AS locNum,
        L.LOC_DS AS locDesc,
        JC.EMPL_JOB_TITL_DS AS jobTitle       
    FROM
        SRCE_HIERARCHY H,
        GSS_AUTHORIZED_SIGNER GAS,
        V1SRCE_ORALOCATION L,
        OOB_JOBCODE_XREF JC       
    WHERE
        GAS.CLIENT_ID = ?       
        AND GAS.DLLR_LMT >= ?       
        AND DECODE(NVL(GAS.VNDR_SITE_ID,0),0,?,GAS.VNDR_SITE_ID) = ?       
        AND DECODE(NVL(GAS.GBL,'0'),'0',?,GAS.GBL) = ?         
        AND DECODE(NVL(GAS.GLOBALACCOUNT,'0'),'0',NVL(?,'0'),GAS.GLOBALACCOUNT) = NVL(?,'0')       
        AND DECODE(NVL(GAS.ORACLE_PROJECT_NUMBER,'0'),'0',NVL(?,'0'),ORACLE_PROJECT_NUMBER) = NVL(?,'0')       
        AND DECODE(NVL(GAS.SUBACCOUNT,'0'),'0',NVL(?,'0'),GAS.SUBACCOUNT) = NVL(?,'0')       
        AND DECODE(NVL(GAS.LOCALACCOUNT,'0'),'0',NVL(?,'0'),GAS.LOCALACCOUNT) = NVL(?,'0')       
        AND DECODE(NVL(GAS.COMPANY,'0'),'0',NVL(?,'0'),GAS.COMPANY) = NVL(?,'0')           
        AND GAS.EMPL_USER_ID =H.EMPL_USER_ID         
        AND L.LOC_NU = H.EMPL_LOC_NU             
        AND JC.EMPL_JOB_TITL_CD = H.EMPL_JOB_TITL_CD         
        AND JC.CLIENT_ID =H.CLIENT_ID   
    ORDER  BY
        H.EMPL_FST_NA,
        H.EMPL_LAST_NA



Calling Peace of code in Java

public List getAlternateApproversList(AuthorizedSignerQueryParams theParms)
       {
              String gbl = theParms.getGbl();
              Long clientId = theParms.getLClientId();
              Long vndrSiteId = theParms.getVendorSiteId();
              Float invcAmt = theParms.getAmount();
              String global = theParms.getGlobal();
              String sub = theParms.getSub();
              String local = theParms.getLocal();
              String company = theParms.getCompany();
              String projectNumber = theParms.getProjectNumber();                  // MARK SNIDER 8/18/2014 projectNumber is passed in now
             
              System.out.println("ACTION: InvoicingDASImple METHOD:getAlternateApproversList gbl " + gbl + " clientId " + clientId + " vndrSiteId " + vndrSiteId + " invcAmt " + invcAmt + " global " + global + " sub " + sub + " local " + local + " company " + company + " projectNumber " + projectNumber);
              List listOfAppvrs = new ArrayList();                         
              Session session = getSessionFactory().openSession();
              Transaction tx =  session.getTransaction();
              Query q = null;
              tx.begin();
                           
              String SQLString = HibernateConstants.CORP_INVOICE_ALTERNATE_APPROVERS_QUERY;
             
              q = session.createSQLQuery(SQLString)
                     .addScalar("emplPpntIdNu", Hibernate.LONG).addScalar("emplUserId", Hibernate.STRING)
                     .addScalar("empFirstName", Hibernate.STRING).addScalar("empLastName", Hibernate.STRING)
                     .addScalar("locNum", Hibernate.STRING).addScalar("locDesc", Hibernate.STRING) //added by kamala -05/22
                     .addScalar("jobTitle", Hibernate.STRING) //added by kamala -05/22
                     .setResultTransformer(Transformers.aliasToBean(DocumentApprovalProfileTo.class));
                     q.setParameter("clientId", clientId);
                     q.setParameter("invcAmt", invcAmt);
                     q.setParameter("vndrSiteId", vndrSiteId);
                     q.setParameter("gbl", gbl);
                     q.setParameter("global", global);
                     q.setParameter("sub", sub);
                     q.setParameter("local", local);
                     q.setParameter("company", company);
                     q.setParameter("projectNumber", projectNumber);        // MARK SNIDER 8/18/2014 projectNumber is passed in now
                     listOfAppvrs.addAll(q.list());                                       // add the result of the query to our list
                     
                     System.out.println("ACTION: InvoicingDASImple METHOD:getAlternateApproversList listOfAppvrs.size() " + listOfAppvrs.size());
              session.flush();
              tx.commit();         
              return listOfAppvrs;
       }

       public static final String CORP_INVOICE_ALTERNATE_APPROVERS_QUERY =  "SELECT distinct"
              + "        H.EMPL_PPNT_ID_NU AS emplPpntIdNu,"
              + "        H.EMPL_USER_ID AS emplUserId,"
              + "        H.EMPL_FST_NA AS empFirstName,"
              + "        H.EMPL_LAST_NA AS empLastName,"
              + "        L.LOC_NU AS locNum,"
              + "        L.LOC_DS AS locDesc,"
              + "        JC.EMPL_JOB_TITL_DS AS jobTitle   "
              + "    FROM"
              + "        SRCE_HIERARCHY H,"
              + "        GSS_AUTHORIZED_SIGNER GAS,"
              + "        V1SRCE_ORALOCATION L,"
              + "        OOB_JOBCODE_XREF JC   "
              + "    WHERE "
              + "        GAS.CLIENT_ID = :clientId"
              + "        AND GAS.DLLR_LMT >= :invcAmt"
              + "        AND DECODE(NVL(GAS.VNDR_SITE_ID,0),0,:vndrSiteId,GAS.VNDR_SITE_ID) = :vndrSiteId"
              + "        AND DECODE(NVL(GAS.GBL,'0'),'0',:gbl,GAS.GBL) = :gbl "
              // MARK SNIDER 8/18/2014 added Global Account Number and Oracle Project Number
              + "        AND DECODE(NVL(GAS.GLOBALACCOUNT,'0'),'0',NVL(:global,'0'),GAS.GLOBALACCOUNT) = NVL(:global,'0')"
              + "        AND DECODE(NVL(GAS.ORACLE_PROJECT_NUMBER,'0'),'0',NVL(:projectNumber,'0'),ORACLE_PROJECT_NUMBER) = NVL(:projectNumber,'0')"
              + "        AND DECODE(NVL(GAS.SUBACCOUNT,'0'),'0',NVL(:sub,'0'),GAS.SUBACCOUNT) = NVL(:sub,'0')"
              + "        AND DECODE(NVL(GAS.LOCALACCOUNT,'0'),'0',NVL(:local,'0'),GAS.LOCALACCOUNT) = NVL(:local,'0')"
              + "        AND DECODE(NVL(GAS.COMPANY,'0'),'0',NVL(:company,'0'),GAS.COMPANY) = NVL(:company,'0')   "
              + "        AND GAS.EMPL_USER_ID =H.EMPL_USER_ID  "
              + "        AND L.LOC_NU = H.EMPL_LOC_NU      "
              + "        AND JC.EMPL_JOB_TITL_CD = H.EMPL_JOB_TITL_CD "
              + "        AND JC.CLIENT_ID =H.CLIENT_ID"
              + "    ORDER  BY  H.EMPL_FST_NA,   H.EMPL_LAST_NA";

Below are the log messages:

[11/23/15 6:18:22:623 CST] 00001d51 SystemOut O ACTION: InvoicingDASImple METHOD:getAlternateApproversList gbl 195500204000 clientId 82475 vndrSiteId 3461918 invcAmt 104375.0 global null sub null local null company null projectNumber 52093
[11/23/15 6:18:22:623 CST] 00001d51 SystemOut O InvoicingDASImpl method: getSessionFactory
[11/23/15 6:18:22:623 CST] 00001d51 SystemOut O InvoicingDASImpl method: getSessionFactory before lookup
[11/23/15 6:18:22:624 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:625 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:626 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:627 CST] 00001d51 SystemOut O Hibernate:
/* dynamic native SQL query */ SELECT
distinct H.EMPL_PPNT_ID_NU AS emplPpntIdNu,
H.EMPL_USER_ID AS emplUserId,
H.EMPL_FST_NA AS empFirstName,
H.EMPL_LAST_NA AS empLastName,
L.LOC_NU AS locNum,
L.LOC_DS AS locDesc,
JC.EMPL_JOB_TITL_DS AS jobTitle
FROM
SRCE_HIERARCHY H,
GSS_AUTHORIZED_SIGNER GAS,
V1SRCE_ORALOCATION L,
OOB_JOBCODE_XREF JC
WHERE
GAS.CLIENT_ID = ?
AND GAS.DLLR_LMT >= ?
AND DECODE(NVL(GAS.VNDR_SITE_ID,0),0,?,GAS.VNDR_SITE_ID) = ?
AND DECODE(NVL(GAS.GBL,'0'),'0',?,GAS.GBL) = ?
AND DECODE(NVL(GAS.GLOBALACCOUNT,'0'),'0',NVL(?,'0'),GAS.GLOBALACCOUNT) = NVL(?,'0')
AND DECODE(NVL(GAS.ORACLE_PROJECT_NUMBER,'0'),'0',NVL(?,'0'),ORACLE_PROJECT_NUMBER) = NVL(?,'0')
AND DECODE(NVL(GAS.SUBACCOUNT,'0'),'0',NVL(?,'0'),GAS.SUBACCOUNT) = NVL(?,'0')
AND DECODE(NVL(GAS.LOCALACCOUNT,'0'),'0',NVL(?,'0'),GAS.LOCALACCOUNT) = NVL(?,'0')
AND DECODE(NVL(GAS.COMPANY,'0'),'0',NVL(?,'0'),GAS.COMPANY) = NVL(?,'0')
AND GAS.EMPL_USER_ID =H.EMPL_USER_ID
AND L.LOC_NU = H.EMPL_LOC_NU
AND JC.EMPL_JOB_TITL_CD = H.EMPL_JOB_TITL_CD
AND JC.CLIENT_ID =H.CLIENT_ID
ORDER BY
H.EMPL_FST_NA,
H.EMPL_LAST_NA
[11/23/15 6:18:22:629 CST] 00001d51 JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 1465, SQLState: 72000
[11/23/15 6:18:22:629 CST] 00001d51 JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions ORA-01465: invalid hex number

[11/23/15 6:18:22:630 CST] 00001d51 NamingHelper I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[11/23/15 6:18:22:630 CST] 00001d51 RemoteExcepti E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getAlternateApproversList" on bean "BeanId(gDataAccessServiceEar#gInvcDASEJB.jar#GInvoicingDASMgr, null)". Exception data: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2147)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)
at com.mcd.invoicing.das.mgr.InvoicingDASImpl.getAlternateApproversList(InvoicingDASImpl.java:17295)
at com.mcd.invoicing.das.mgr.GInvoicingDASMgrBean.getAlternateApproversList(GInvoicingDASMgrBean.java:3252)
at com.mcd.invoicing.das.mgr.EJSRemoteStatelessGInvoicingDASMgr_8bcd7987.getAlternateApproversList(EJSRemoteStatelessGInvoicingDASMgr_8bcd7987.java:4794)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.rmi.util.ProxyUtil$4.run(ProxyUtil.java:612)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.rmi.util.ProxyUtil.invokeWithClassLoaders(ProxyUtil.java:547)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java:1165)
at $Proxy47.getAlternateApproversList(Unknown Source)
at com.mcd.invoicing.das.mgr._GInvoicingDASMgr_Stub.getAlternateApproversList(_GInvoicingDASMgr_Stub.java:22001)
at com.mcd.invoicing.client.facade.GInvoicingFacadeBean.getAlternateApproversList(GInvoicingFacadeBean.java:5181)
at com.mcd.invoicing.client.facade.EJSRemoteStatelessGInvoicingFacade_af197413.getAlternateApproversList(EJSRemoteStatelessGInvoicingFacade_af197413.java:4342)
at com.mcd.invoicing.client.facade._GInvoicingFacade_Stub.getAlternateApproversList(_GInvoicingFacade_Stub.java:21215)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.processApproval(SubmitCorpReviewInvoiceAction.java:329)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.execute(SubmitCorpReviewInvoiceAction.java:188)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1772)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)
Caused by: java.sql.SQLException: ORA-01465: invalid hex number

at java.lang.Throwable.<init>(Throwable.java:67)
at java.sql.SQLException.<init>(SQLException.java:101)
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:68)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1104)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:725)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
... 57 more

[11/23/15 6:18:22:632 CST] 00001d51 RemoteExcepti E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getAlternateApproversList" on bean "BeanId(gUIEar#gInvoicingUIFacade.jar#GInvoicingFacade, null)". Exception data: javax.ejb.EJBException: CORBA TRANSACTION_ROLLEDBACK 0x0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is:
org.hibernate.exception.GenericJDBCException: could not execute query vmcid: 0x0 minor code: 0 completed: No
at com.mcd.invoicing.client.facade.GInvoicingFacadeBean.getAlternateApproversList(GInvoicingFacadeBean.java:5183)
at com.mcd.invoicing.client.facade.EJSRemoteStatelessGInvoicingFacade_af197413.getAlternateApproversList(EJSRemoteStatelessGInvoicingFacade_af197413.java:4342)
at com.mcd.invoicing.client.facade._GInvoicingFacade_Stub.getAlternateApproversList(_GInvoicingFacade_Stub.java:21215)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.processApproval(SubmitCorpReviewInvoiceAction.java:329)
at com.mcd.invoicing.web.actions.SubmitCorpReviewInvoiceAction.execute(SubmitCorpReviewInvoiceAction.java:188)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1772)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)

First, try to isolate the problem.
You could first check if the SQL is properly executed on the JDBC layer-side.
For this, you need to remove the:



and simply return the Object[] result.

If that still fails, you need to manually check which parameter might cause you the problem.

Thank you very much for giving response.

We are getting above mentioned error

Quote:

ORA-01465:invalid hex number

in Production.
But I am unable to replicate the same issue in local development environment.
we are using the same code and data in both Production and local.
Could you please help me to understand why this issue is occurring in Production but not in Local Development Environment.
How to replicate the same issue in local to provide the resolution.

You'll have to take a database dump from production and run it on your development environment and check the column that's causing the issue.