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)
Searched on Google with the first line of a JAVA stack trace?
We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.
Recommended solutions based on your search
Solutions on the web
via blogspot.com by Unknown author, 2 years ago
via blogspot.nl by Unknown author, 1 year ago
via Oracle Community by Jigar Kothari, 1 year ago
via Oracle Community by 336358, 9 months ago
via Oracle Community by 304584, 1 year ago
via Oracle Community by 452485, 8 months ago
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)