java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00103: Encountered the symbol "." when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

Solutions on the web

via Oracle Community by user10719205, 1 year ago
ORA-06550: line 2, column 22: PLS-00103: Encountered the symbol "." when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset
via Coderanch by Ravi Majety, 11 months ago
ORA-21700: object does not exist or is marked for delete ORA-06512: at "BusLogic ", line 99 ORA-06512: at line 1
via Oracle Community by 856967, 1 year ago
ORA-06550: line 1, column 28: PLS-00103: Encountered the symbol "COMPUTER" when expecting one of the following: . ( ) , * @ % & = - + < / > at in is mod remainder not rem => <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec as between from using || multiset member submultiset The symbol ". was inserted before "COMPUTER" to continue.
via Oracle Community by 856967, 1 year ago
ORA-06550: line 1, column 28: PLS-00103: Encountered the symbol "COMPUTER" when expecting one of the following: . ( ) , * @ % & = - + < / > at in is mod remainder not rem => <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec as between from using || multiset member submultiset The symbol ". was inserted before "COMPUTER" to continue.
via Oracle Community by 822737, 3 months ago
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'EMPLOYEE_DETAILS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
java.sql.SQLException: ORA-06550: line 2, column 22: PLS-00103: Encountered the symbol "." when expecting one of the following: * &amp; = - + ; &lt; / > at in is mod remainder not rem &lt;an exponent (**)> &lt;> or != or ~= >= &lt;= &lt;> and or like like2 like4 likec between || multiset member submultiset
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at oracle.xdo.dataengine.datasource.PlsqlFunctionCall.getRemoteValue(PlsqlFunctionCall.java:165)
at oracle.xdo.dataengine.DataHandler.getRemoteValue(DataHandler.java:976)
at oracle.xdo.dataengine.DataHandler.getBindValue(DataHandler.java:371)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 3 weeks ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.