java.sql.SQLException: ORA-06550: line 2, column 1: PLS-00103: Encountered the symbol "@" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge

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 Anindya Chatterjee90, 1 year ago
ORA-06550: line 2, column 1: PLS-00103: Encountered the symbol "@" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited
via Oracle Community by 3433634, 4 months ago
ORA-06550: line 2, column 2: PLS-00905: object HR.GET_EMP_JSON is invalid ORA-06550: line 2, column 2: PL/SQL: Statement ignored
via Oracle Community by TAjinkya, 1 year ago
via Oracle Community by maniku, 1 year ago
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
via blogspot.com by Unknown author, 2 years ago
ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00253: missing required version number in XML declaration Error at line 1
java.sql.SQLException: ORA-06550: line 2, column 1: PLS-00103: Encountered the symbol "@" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago

Write tip

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