java.sql.SQLException: ORA-06550: line 1, column 39: PLS-00103: Encountered the symbol "?" when expecting one of the following: ( ) - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month DAY_ hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date <a string literal with character set specification>

Oracle Community | Mazhar Hussain | 5 years ago
  1. 0

    Jdeveloper hello world Exception&#160; java.sql.SQLException

    Oracle Community | 5 years ago | Mazhar Hussain
    java.sql.SQLException: ORA-06550: line 1, column 39: PLS-00103: Encountered the symbol "?" when expecting one of the following: ( ) - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month DAY_ hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date <a string literal with character set specification>
  2. 0

    Error when running page in R12

    Oracle Community | 10 years ago | SOA
    java.sql.SQLException: ORA-06550: line 1, column 39: PLS-00103: Encountered the symbol "?" when expecting one of the following: ( ) - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month DAY_ hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date <a string literal with character set specification>
  3. 0

    URGENT!!! JDev 10g With OA Extension Error On R12.

    Oracle Community | 10 years ago | user570355
    java.sql.SQLException: ORA-06550: line 1, column 39: PLS-00103: Encountered the symbol "?" when expecting one of the following: ( ) - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month DAY_ hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date <a string literal with character set specification>
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem with Release 12 OAF extension

    Oracle Community | 10 years ago | user464416
    java.sql.SQLException: ORA-06550: line 1, column 39: PLS-00103: Encountered the symbol "?" when expecting one of the following: ( ) - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month DAY_ hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date <a string literal with character set specification>
  6. 0

    Encountered the symbol "?" when expecting one of the following:

    Oracle Community | 9 years ago | 607060
    java.sql.SQLException: ORA-06550: line 1, column 39: PLS-00103: Encountered the symbol "?" when expecting one of the following: ( ) - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month DAY_ hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date <a string literal with character set specification>

    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-06550: line 1, column 39: PLS-00103: Encountered the symbol "?" when expecting one of the following: ( ) - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month DAY_ hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date <a string literal with character set specification>

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      TIMESTAMP.TimeZoneConvert
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      5. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
      6. oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
      8. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      9. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3093)
      10. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4286)
      11. oracle.sql.TRANSDUMP.getTransitions(TRANSDUMP.java:59)
      12. oracle.sql.TIMEZONETAB.updateTable(TIMEZONETAB.java:456)
      13. oracle.sql.TIMESTAMPLTZ.getZoneOffset(TIMESTAMPLTZ.java:1842)
      14. oracle.sql.TIMESTAMPLTZ.TimeZoneAdjust(TIMESTAMPLTZ.java:1715)
      15. oracle.sql.TIMESTAMP.TimeZoneConvert(TIMESTAMP.java:677)
      15 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.util.OracleTimezone.convertTimezone9i(OracleTimezone.java:317)
      2. oracle.apps.fnd.util.OracleTimezone.convertTimezone(OracleTimezone.java:264)
      3. oracle.apps.fnd.framework.OANLSServices.convertTimezone(Unknown Source)
      4. oracle.apps.fnd.framework.OANLSServices.getUserLocaleContextInternal(Unknown Source)
      5. oracle.apps.fnd.framework.OANLSServices.getUserLocaleContext(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OARenderingContext.initLocaleContext(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OARenderingContext.configure(Unknown Source)
      8. oracle.apps.fnd.framework.webui.OARenderingContext.<init>(Unknown Source)
      9. oracle.apps.fnd.framework.webui.OAPageContextImpl.<init>(Unknown Source)
      10. oracle.apps.fnd.framework.webui.OAPageBean.createPageContext(Unknown Source)
      11. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      12. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      13. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      13 frames