You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Bind variable does not pass through to the SQL query

Accepted answer


When I give the variable a value from integration, no rows are extracted from the SQL source. but the log says the bind variable was added.

--------------- Executing Custom Event :BefExtract ---------------

Aug-22 07:57:58:722 :: Adding String Bind Variable: STARTMONTH with value: 'JAN-23'

But when I hardcode the value in the query directly it pulls data.

Can't seem to figure out what I am doing wrong.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!