Toad for Oracle ignores alphanumeric parameters without quotes (4284327)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Toad for Oracle ignores alphanumeric parameters without quotes
Description

Script runs fine in sqlplus but Toad for Oracle ignores the parameter unless it is enclosed in quotes.
It allows other alphanumeric characters like ABCD. It also ignores table and other "reserved" words.
Cause

If a line in a script calls another script with a parameter, like this:
@c:\temp\vars.sql TEST
but the parameter happens to be a SQL keyword like this:
@c:\temp\vars.sql COMMIT
then the parameter is not sent to the script.
Note: The middle call to vars.sql does not pass the COMMIT parameter to the script. TABLE doesn't work either, but also works if quoted.
Resolution

This is a known product defect and there is an open defect ID: TOR-6028, the Toad DEV team is engaged and working on this issue.
Workaround:
For now, use quotes or do not use reserved words such as TABLE.
Defect ID

TOR-6028
Additional Information

open defect ID: TOR-6028

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title