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 <an identifier> <a double-quoted delimited-identifier> <a bind variable> table continue 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 | 770889 | 7 years ago
  1. 0

    Getting Error when run the custom page in Jdeveloper 10.1.3

    Oracle Community | 7 years ago | bmn
    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 <an identifier> <a double-quoted delimited-identifier> <a bind variable> table continue 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

    Problems executing test_fwktutorial.jsp in JDeveloper

    Oracle Community | 7 years ago | 770889
    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 <an identifier> <a double-quoted delimited-identifier> <a bind variable> table continue 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

    getting error while running the hello page

    Oracle Community | 7 years ago | user119558
    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 <an identifier> <a double-quoted delimited-identifier> <a bind variable> table continue 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

    handling escape characters in R12 versus 11i

    Oracle Community | 5 years ago | Asmirnov-Oracle
    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 table continue 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
  6. 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>

    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 <an identifier> <a double-quoted delimited-identifier> <a bind variable> table continue 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