SET DEFINE OFF in glogin.sql changes escaped characters to UPPERCASE when executed as script (F5). (4308334)

Chat now with support

Return

Did this article solve an issue for you?

[Select Rating]

Title

SET DEFINE OFF in glogin.sql changes escaped characters to UPPERCASE when executed as script (F5).
Description

When the 'glogin.sql' script has a statement "set define off;", and a script is run from the Editor via F5 (Execute as Script), even though it doesn't prompt for substitution variables, the compiled code has those strings with '&' characters as UPPERCASE.

Example:

CREATE PROCEDURE x
AS
a VARCHAR2 (10);
BEGIN
a := '&abc';
END;

The file 'glogin.sql' has the statement "set define off;" and can be checked in Toad Options | Scripts | glogin.sql.

Here's how the glogin.sql file looks like:

SET ECHO ON;
SET DEFINE OFF;


When run as F5, this is the output:

SQL> set define off
SQL> CREATE PROCEDURE x
AS
a VARCHAR2 (10);
BEGIN
a := '&ABC';
END;
Procedure created.

The string inside single quotes changed and is now stored as UPPERCASE in the procedure in the database.

Note that manually running set define off before compilation doesn't have a problem. It's only when the glogin.sql file has 'set define off;', that the case being changed to uppercase.

Also note that "Execute via SQL Plus" does not have this problem and correctly preserves the case when using glogin.sql.
Resolution

WORKAROUND:
Use 'Execute via SQL Plus" (under Editor menu), which will not cause the issue.

STATUS:
Issue fixed in version 13.0. The latest version of Toad for Oracle can be downloaded at: https://support.quest.com/download-product-select
Defect ID

TOR-2155

Did this article solve an issue for you?

[Select Rating]

Title