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

Oracle Community | Asmirnov-Oracle | 5 years ago
  1. 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
  2. 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>
  3. 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>
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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>
  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 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

      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