java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)

Oracle Community | user13333117 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Oracle Business Intelligence Publisher Stuck

    Oracle Community | 2 years ago | user13333117
    java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)
  2. 0

    how to store string with "?" without binding parameters

    Oracle Community | 1 decade ago | 370922
    java.sql.SQLException: Number of input values does not match number of question marks ERROR CODE: -79749
  3. 0

    db:: 5.06::error exception unknown 3d

    hivmr.com | 1 year ago
    java.sql.SQLException: Io exception: Connection reset by peer: socket write error ERROR CODE: 17002
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 5.33::JUnit Help Please. sc

    hivmr.com | 1 year ago
    java.sql.SQLException: Invalid column type Error Code: 17004 Call: BEGIN XL_MAP_TEST(?); END; bind = [null = poData] Query: ValueReadQuery()
  6. 0

    Calling an Oracle stored procedure using Toplin... | Oracle Community

    oracle.com | 1 year ago
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GET_NEXT_VALUE' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Error Code: 6550

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)

      at oracle.toplink.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.exceptions
      DatabaseException.sqlException
      1. oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
      1 frame
    3. oracle.toplink.internal
      DatabaseAccessor.executeCall
      1. oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:613)
      2. oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:467)
      2 frames