Script treats define prv = 6606IN0006 as a number 6606 (4310499)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Script treats define prv = 6606IN0006 as a number 6606
Description

When executing a script in TOAD the following command
define prv = 6606IN0006 values substitution variable prv as a number 6606 while it should be alphanumeric 6606IN0006.
This behaves differently from SQL-PLUS.
Resolution

WORKAROUND
Surround the variable with single quotes e.g. define prv = 6606IN0006
STATUS
Waiting for fix in a future release of Toad for Oracle
Defect ID

TMB-2000

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title