Posted: Tue Jan 09, 2007 1:34 pm
I don't have Oracle available to me right now or I would test this myself and not waste your time should this suggestion be whacked but I gotta believe some combination of triple tick marks (definitely not double quotes) would work.
'''A690','R456','F1234'''
select * from table where codes IN (#p_in_clause#)
or
''A690','R456','F1234''
select * from table where codes IN ('#p_in_clause#')
'''A690','R456','F1234'''
select * from table where codes IN (#p_in_clause#)
or
''A690','R456','F1234''
select * from table where codes IN ('#p_in_clause#')