Toad World® Forums

Alter session statements


#21

Hi Tony,

Sory for reopening this thread, but need to.

When I use test binds set, alter session is not working as you told…it is ignored regardless it is defined in SQL details tabl (on grid list of queries).

So how to implement that on “Test run with Different BIND values” alter session setting?

Brg

Damir


#22

Other than the list from session Parameters list, we have no solution to change the alter session setting. But some of them such as hint applied, you may contain within the SQL and add the SQL as user-defined alternative.

Thanks,

Tony Ng


#23

Hi Tony;
Sorry for being not too clear.
“ALTER SESSION” list that you provided in “SQL details” tab are enough.

Problem is that in “Test Run Different Bind Values” this is not used and IN THAT TAB there is no way to define ALTER SESSION NLS_DAT_FORMAT command (for instance):

Is it clear now enough?
Brg
Damir


#24

In the Bind Values testing, the session parameters currently have no ways to apply. We could fix it on next release, however, I have no workaround on change the NLS_DAT_FORMAT.

Sorry about it.

Tony Ng


#25

Hi Tony;
Good that we are clear now.
Brg
Damir