Skip to content

SQLcl ezconnect with special characters!@

  • by

While connecting to a remote Oracle database using SQLcl ezconnect syntax with special characters in the password, the syntax requires below escape characters (\), especially if you’ve a “@” character in your password.

sql system/\“abMgYP!@S12\“@//<hostname>:<port>/<service_name>

Without proper escape characters, it’ll fail with below errors…

Error Message = IO Error: Invalid connection string format, a valid format is: “//host[:port][/service_name]”

Leave a Reply

Your email address will not be published. Required fields are marked *