We plan to make this a lot easier in the next release by giving Proxy Authentication it's own section in the connection dialog. But in this release you will need to use an "ODP.NET connection string".
Here are the steps to follow:
- To connect to Oracle Database from a .SQL or .PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown
- To connect from Oracle Database Explorer, click the plus sign button
- A connection dialog will open. In the Connection Type dropdown, select ODP.NET Connect String
- In the Connection String field, enter a string with this format if providing the hostname, port and service name explicitly: User Id=myuser;Data Source=dbhostname:1521/DBSERVICENAME;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
- If using a TNS Alias, enter a connect string with this format: User Id=myuser;Data Source=mytnsalias;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
- Provide a connection name to be used to reference this connection in Database Explorer and elsewhere
- Click the Create Connection button
thanks for yout fast response, this works perfect.
The only downside is, that you have to store your password. But thats fine for me.
Even easier than an own section for proxy connect would be, if the "square-bracket-syntax" would work, e.g. scott[hr].
SQLDeveloper works that way.