An "&" anywhere triggers Bind variable logic

Toad Data Point & Toad Intelligence Central
1

I am running an Automation script in TDP3.4 which ran fine in 3.2 and earlier versions.

When it executes a SQL (Select to File), I get the error:

Reporting_Daily.log: AllUP - Toad has detected some symbols within the expression indicating you might be using bind variables. Please define the following variable(s):

Y

This sql contains the following:

SELECT ALL

…

decode(USING_DEPARTMENT,‘17A’,‘Carlin - AN&Y’,‘17N’,‘Carlin - AN&Y’,‘17Y’,‘Carlin - AN&Y’,‘17C’,‘Chasin - Center’, ‘OtherManager’) IPTmgr,

…

Is there a way to avoid this error when the “&” only appears in quoted text?

Also, a similar error:

Exception Messages:

AllUP_SW_Extract - Toad has detected some symbols within the expression indicating you might be using bind variables. Please define the following variable(s):

Chains

This sql contains the following:

/* List all tool orders, open and complete, released for the Safety Walk effort to enhance Posts&Chains, Flopboards&sliders */

SELECT ALL

…

** **This time the “&” appears within a comment, where it should be ‘inert’.

2

That is a bug. I entered QAT-1545 to fix. Hopefully we can can fixed in the next Beta. There isn’t any work arounds. In the editor we added a tool button that let’s you request to scan for that type of bind var or not to scan and tread as bind var. We will need something similar to that in automation.

3

I had the same issue and solved it including in my query char(38) instead of &.

It went well.

P.

4

FYI QAT-1545 was fixed in TDP 3.5.

5

Seems like the bug os back again in 4.3. I has to change several scripts with the new version.

El lun., 20 nov. 2017 19:06, Debbie Peabody bounce-Debbie_Peabody@toadworld.com escribió:

RE: An "&" anywhere triggers Bind variable logic

Reply by Debbie Peabody
FYI QAT-1545 was fixed in TDP 3.5.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad Data Point Forum notifications altogether.

Toad Data Point - Discussion Forum

Flag this post as spam/abuse.

Grupo Paraninfo

Centro Cívico Comercial

C/ Comandante Caballero s/n Oficina 6, 2º planta

33005 Oviedo (Asturias)

www.paraninfo.es

http://www.facebook.com/GrupoEditorialParaninfo

https://twitter.com/GrupoParaninfo

6

Hi,

can you give me detail about provider?

Thank you.J

7

We did some testing using Oracle connection and do not see an issue. Can you tell us what module and connection you were using and the resulting erroring. A screenshot would be helpful and if the issue occurs in automation the script and log file should be uploaded.

8

Hi:

I had the issue with Toad Data Point 4.3 not in the TSM execution but in the execution of the TSM on a TAS.

This would generate an error on the TAS when placed on a “Select to file” task

SELECT DISTINCT
( 'play.google.com/…/linkbuilder

  • ITES_EU$Item.No_)
  • ‘&country=ES&vertical=BOOK&language=es’
    AS Scraping_Google
    FROM PARANINFO_2013.dbo.ITES_EU$Item ITES_EU$Item

This is the corrected

SELECT DISTINCT
ITES_EU$Item.No_,
( ( ( ( ( ( ( ( 'play.google.com/…/linkbuilder

  • char (38))
  • ‘query=’)
  • ITES_EU$Item.No_)
  • char (38))
  • ‘country=ES’)
  • char (38))
  • ‘vertical=BOOK’)
  • char (38))
  • ‘language=es’
    AS Scraping_Google,
    ITES_EU$Item.[Firmados Derechos Digital]
    FROM PARANINFO_2013.dbo.ITES_EU$Item ITES_EU$Item
9

Hi pelayo,

i have confirmed your issue and entered the task QAT-11969.

J.