Different prompts in sqlplus and sqlcl

3629179

I have primary and standby database with ORACLE_SID's XXX_S1 and XXX_S2.

I defined in glogin.sql my prompt as:

set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE > "

I use both sqlplus and sqlcl.

In sqlplus i see the prompt I expected:

sqlplus / as sysdba

[email protected]_S1 AS SYSDBA >

but when i use sqlcl i see only:

sql / as sysdba

[email protected] AS SYSDBA >

Why "_S1" dissapeared?

Gaz in Oz

copy/pasting the above set sqlprompt into sqlcl 18.1.0.0 works for me.

what sqlcl ver are you using?

SQL> def _connect_identifierSQL> show versionOracle SQLDeveloper Command-Line (SQLcl) version: 18.1.0.0SQL> set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE > "[email protected]_1  >

Does it work from the sqlcl command-line as above?

Is it just the glogin.sql declaration that doesn't behave as you would expect?

Is it the version of sqlcl you are using?

3629179

I am using 12.2 of sqlcl

sql -v

SQLcl: Release 12.2.0.1.0 RC

in sqlplus i see:

define

...

DEFINE _CONNECT_IDENTIFIER = "XXX_S1" (CHAR)

in sqlcl

define

...

DEFINE _CONNECT_IDENTIFIER =  "XXX" (CHAR)

Gaz in Oz

...so it is a bug in sqlcl version 12.2.0.1.0...

Works in 18.1.0.0 as shown.

Download the latest from here:

https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

and see how you go.