Passing macro with quotes to Oracle server

[ammarhm]

I am trying to pass a string using a macro variable to an oracle server to extract data. The string will serve as a Where string. THe final product should be passed to the Oracle server like this

Select *
from DB
where column in ('A', 'B')
quit
;

However, i need the column variable to be passed in using a macro variable. Here is what I am trying to solve it:

%let column="('A','B')";

Select *
from DB
where column in %bquote(&column)
quit
;

This is however generating an error, which is mostly related to the quotes I think. I tried %unquote but no luck.

Anyone has a solution to this please?

[novinosrin · Accepted solution]

Why are wrapping your macro variable with double quotes

I don't think this 

%let column="('A','B')";

is needed.

The following should suffice

%let column=('A','B');