SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER SESSION command in login.sql

robdumoulinAug 9 2017 — edited Aug 10 2017

I am using SQL Developer 4.2.0.17.089 Build 17.089.1709.

JAVA version 1.8.0_121

RDBMS version is 12.1.0.2.0

I have used glogin.sql and login.sql on SQL Dev before with no issues. Now, I am trying to create a login.sql file to change the default character length from BYTES to CHAR at my session level using login.sql and the following command:

ALTER SESSION SET nls_length_semantics=CHAR

I can execute the command interactively with no issues. If I add it to the login.sql file containing only simple SET commands, it hangs and has to be killed. I know that the login.sql file is being run because all I have to do is comment out that statement and it works fine.

Is an ALTER SESSION command invalid to have in login.sql?

Added on Aug 9 2017

8 comments

1,843 views