My Oracle Support Banner

Connect String In SQL Developer Worksheet Is Rejected With Message, "Connection created by CONNECT script command disconnected" (Doc ID 1505323.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle SQL Developer - Version 1.5 and later
Information in this document applies to any platform.

Symptoms

When working in an active connection's SQL Worksheet, issuing a connect string for a different connection raises a message:

Message

"Connection created by CONNECT script command disconnected"

Issuing a query to determine current user/schema shows the connection script does not change the current user/schema:

SELECT sys_context('userenv', 'current_schema')

 ...shows the user/schema for the active connection is unchanged.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.