Oracle Database Discussions

Hi,

I have seen sometimes the queries which work in oracle sql*plus and Pl/Sql Developer,they dont work in Oracle forms, for example following query works in
Pl/sql developer,but not in oracle forms

select *
from tablea
where name in (variable)

so if variable ='AA','BB'
and records are there in table ,it will not fetch any records,whether variable is with quotes or not .........

whenever there is a dml statement involving variables ..behavior is somewhat different ....so to get that done ....i normally transfer them to database procedure or function .....then it works fine ..

Is it known bug or what.

Regards,
SS