Role/Alter Session section in Options

Toad for Oracle - Beta
1

This pertains to the latest Beta, but also back to 2025R3.

I love this and have 6 alter session commands I use.

I recently changed one, hit apply and it kept the change. All good.If I add another

If I add another, define it, and hit apply, I get an error. see pic.

If I yes to the error to combine it appends the first alter session with this new command?

Is that valid?

Toad_RoleAlterSessAddError
Toad_RoleAlterSessAddError1185×588 10.6 KB

2

Hi Brad,

Yeah, the "limit of 1" rule is mainly for roles, but to keep things simpler we apply it to alter session as well.

Combining should work, although some of those aren't valid ALTER SET commands.

For example,

  1. numformat, linesize and pagesize are SQL*Plus commands, not ALTER SESSION SET commands - so they are processed by SQL*Plus, not the database itself. You can see a list of those here.
  2. ENABLE PARALLEL DML is an ALTER SESSION command, but it doesn't fall under 'SET'.

Here is the ALTER SESSION docs so you can see what's allowed with SET

I'd recommend testing it in the editor to get single command that works - I got this to work:

alter session set nls_length_semantics = 'CHAR' remote_dependencies_mode=signature

and you could put that in Toad like this:

image
image1158×636 20.7 KB

3

Thanks, I made note of this and will change it on my end.

Brad