Parameterized Query Not Functioning on Oracle DB with LIKE Statement?

Toa_Lihkan
Toa_Lihkan
in Integrations

Greetings,

I am trying to run the query below to return emails that are like the current user email who is initiating this.

image.png

However, I don't get any query results when I run this. I'm connecting to an Oracle DB. Any suggestions?

Comments

  • gregory_Decisions
    gregory_Decisions

    Hello there!

    You will want to alter the LIKE (%:email%) to LIKE '%'||:email||'%' if you are connecting to Oracle. This should resolve the issue.

    -Gregory

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories