I was sent a select statement from another Toad user in my department that is on a different version of Toad. I have Toad for Data Analysts.
He created the query with 4 variables. When he runs it, the variable box appears and works fine. When I copy the exact same SQL into the editor and run the query I get an error "not all variables bound".
These are how the variables appear in his sql
and pd.PO_DISTRIBUTION_ID like: pod_id
and V.VENDOR_NAME like:vendor
and ph.ORG_ID like:org and to_char(RCT.CREATION_DATE,'YYYYMM') like:period
Why won't my version display the variable prompt box?
|
