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
(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)
via blogspot.nl by Unknown author, 1 year ago
(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)
via Oracle Community by Jigar Kothari, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT effective_date FROM MEDICARE_FEE_SCHEDULE WHERE PROCEDURE_CODE =:ProcCode AND LOCALITY_PSRO = :Locality AND :ProcDate > EFFECTIVE_DATE AND EFFECTIVE_DATE = (SELECT MAX(EFFECTIVE_DATE) FROM MEDICARE_FEE_SCHEDULE WHERE PROCEDURE_CODE = :ProcCode AND LOCALITY_PSRO = :Locality AND :ProcDate > EFFECTIVE_DATE)
via Oracle Community by 336358, 9 months ago
JBO-27122: SQL error during statement preparation. Statement: SELECT blah, blah FROM MYTABLE MyTableEo WHERE ? = MyTableEo.LINKCOLUMN
via Oracle Community by 304584, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: select * from emp
via Oracle Community by 452485, 8 months ago
JBO-27122: SQL error during statement preparation.
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)