Return
-
Title
Toad adds procedure "CaptureOldAndSetNewNLS " in the jobs script -
Description
After upgrading Toad for Oracle to version 13.2, Toad adds some unwanted procedures on the script tab in Schema Browser | Jobs.See the code added below:procedure CaptureOldAndSetNewNLS asbeginselect VALUEinto langfrom v$nls_parameterswhere parameter = 'NLS_LANGUAGE';execute immediate 'alter session set nls_language=ENGLISH';end;procedure RestoreNLS asbeginexecute immediate 'alter session set nls_language = ' || Lang;end;
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.