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>

Samebug tips0

We couldn't find tips for this exception.

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

Solutions on the web2192

  • via Unknown by Mazhar Hussain,
  • via Unknown by user570355,
  • via Unknown by user464416,
  • 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 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(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 visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    76 more bugmates