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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web16601

  • via Oracle Community by Asmirnov-Oracle, 11 months ago
    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
  • via Oracle Community by 770889, 1 year ago
    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>
  • via Oracle Community by user119558, 1 year ago
    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>
  • Stack trace

    • 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(DatabaseError.java:138) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184) at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3093) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4286) at oracle.sql.TRANSDUMP.getTransitions(TRANSDUMP.java:59) at oracle.sql.TIMEZONETAB.updateTable(TIMEZONETAB.java:456) at oracle.sql.TIMESTAMPLTZ.getZoneOffset(TIMESTAMPLTZ.java:1842) at oracle.sql.TIMESTAMPLTZ.TimeZoneAdjust(TIMESTAMPLTZ.java:1715) at oracle.sql.TIMESTAMP.TimeZoneConvert(TIMESTAMP.java:677) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at oracle.apps.fnd.util.OracleTimezone.convertTimezone9i(OracleTimezone.java:317) at oracle.apps.fnd.util.OracleTimezone.convertTimezone(OracleTimezone.java:264) at oracle.apps.fnd.framework.OANLSServices.convertTimezone(Unknown Source) at oracle.apps.fnd.framework.OANLSServices.getUserLocaleContextInternal(Unknown Source) at oracle.apps.fnd.framework.OANLSServices.getUserLocaleContext(Unknown Source) at oracle.apps.fnd.framework.webui.OARenderingContext.initLocaleContext(Unknown Source) at oracle.apps.fnd.framework.webui.OARenderingContext.configure(Unknown Source) at oracle.apps.fnd.framework.webui.OARenderingContext.<init>(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageContextImpl.<init>(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.createPageContext(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 3 months ago
    Unknown user
    Once, 9 months ago
    Unknown user
    Once, 9 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    76 more bugmates