Return
-
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 TESTbut the parameter happens to be a SQL keyword like this:@c:\temp\vars.sql COMMITthen 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