Toad's editor doesn't recognze and EZConnect statement. If a script is run that uses this statement, TOAD gives a pop-up window asking to provide connection information again. It seems that it does not regonize the database specified and instead fills out the file using the current database connection info (which is not the same as specified in the statement).
Is there a way to avoid Connect pop-up when executing a script with the connect command?
Sample of connection statement:
connect user1/userpwd@databaseA/service
WORKAROUND:
Toad is expecting the port number. Please include the port when using EZConnect and the connection string in Toad/scripts.
CONNECT username/password@[//]host[:port][/service_name]
sample: CONNECT maui/maui@alv54abc:1521/alv54
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center