start PL/SQL Developer with Command-line parameters

Gloria

Member
"Every time you start PL/SQL Developer, it will prompt you for at least the password. To avoid this, you
can supply a userid parameter with the familiar username/password@database format:

plsqldev.exe userid=scott/tiger@chicago "

What if there is an "@" symbol in my password?

For example, my password is "test@ev513",
plsqldev.exe userid=username/test@ev513@database
The programe will take "test" as the password and "ev513@bjtest4a" as the database name.

 
Try putting the password in double quotes:
userid=username/"test@ev513"@database

Please note, that when you use double quotes, the content inside the quotes become case sensitive. In earlier database versions, the password was not case sensitive, but was always made uppercase internally so passwords mypassword and MYPASSWORD was treated as the same.
 
The quotation marks is useful in sqlplus while there is "/" or "@" in password.
But it doesn't work in PL/SQL Developer :(

 
Did anyone ever find a solution to this? I have |pipe|, ;semi-colon;, and /slash/ in my password!!

I have escaped the necessary characters correctly for sqlplus, but the same escaping does not work starting PL/SQL Dev'r from the cmdline :eek:
 
Back
Top