oracle.jbo.SQLStmtException

JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT the_key, ProdLineKey,ProdLineDesc, ProdSegKey FROM (SELECT 1 the_key, TO_CHAR(trim(SRSRP2)) ProdLineKey, TO_CHAR(trim(SRDL02)) ProdLineDesc, TRIM (SRSRP1) ProdSegKey FROM F590001 WHERE trim(SRSRP1) IS NOT NULL AND trim(SRSRP1) IN (SELECT TO_CHAR(trim(DRKY)) FROM F0005 WHERE trim (DRSY) = '41' AND trim(drrt) = 'S1' AND trim(drsphd) = 'CPP' ) UNION ALL SELECT DISTINCT 2 the_key, TO_CHAR(trim(SRSRP2)) ProdLineKey, TO_CHAR(trim(SRDL02)) ProdLineDesc, NULL ProdSegKey FROM F590001 WHERE trim(SRSRP1) IS NOT NULL AND trim(SRSRP1) IN (SELECT TO_CHAR(trim(DRKY)) FROM F0005 WHERE trim (DRSY) = '41' AND trim(drrt) = 'S1' AND trim(drsphd) = 'CPP' ) )) QRSLT WHERE (:Bind_Prodsegkey is null and the_key = 2)or (:Bind_Prodsegkey is not null and the_key=1 and :Bind_Prodsegkey = ProdSegKey)

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web15

  • Stack trace

    • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT the_key, ProdLineKey,ProdLineDesc, ProdSegKey FROM (SELECT 1 the_key, TO_CHAR(trim(SRSRP2)) ProdLineKey, TO_CHAR(trim(SRDL02)) ProdLineDesc, TRIM (SRSRP1) ProdSegKey FROM F590001 WHERE trim(SRSRP1) IS NOT NULL AND trim(SRSRP1) IN (SELECT TO_CHAR(trim(DRKY)) FROM F0005 WHERE trim (DRSY) = '41' AND trim(drrt) = 'S1' AND trim(drsphd) = 'CPP' ) UNION ALL SELECT DISTINCT 2 the_key, TO_CHAR(trim(SRSRP2)) ProdLineKey, TO_CHAR(trim(SRDL02)) ProdLineDesc, NULL ProdSegKey FROM F590001 WHERE trim(SRSRP1) IS NOT NULL AND trim(SRSRP1) IN (SELECT TO_CHAR(trim(DRKY)) FROM F0005 WHERE trim (DRSY) = '41' AND trim(drrt) = 'S1' AND trim(drsphd) = 'CPP' ) )) QRSLT WHERE (:Bind_Prodsegkey is null and the_key = 2)or (:Bind_Prodsegkey is not null and the_key=1 and :Bind_Prodsegkey = ProdSegKey) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1293) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:968) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7178) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1217) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1062) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2810) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2788)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,