Hi every body,
I am trying to run the sql below as a region source and am getting an ORA error - invalid relational operator. Can anyone please help me?
The code is as follows:
select
htmldb_item.checkbox(1,a.column_name,null,:P500_COLUMN_NAMES),
DECODE(a.data_type, 'NUMBER', '<img src="/i/number.gif">', 'DATE',
'<img src="/i/date.gif">', '<img src="/i/varchar.gif">') ||
htmldb_item.hidden(3,data_type) || htmldb_item.hidden(4,a.column_name)
data_type_icon,
a.column_name,
CASE when instr(upper(a.column_name),'JOB')>0 then htmldb_item.hidden(10,a.column_name)||HTMLDB_ITEM.SELECT_LIST_FROM_LOV(2,b.filter_value,'JOBS_LOV')
else
htmldb_item.hidden(10,a.column_name)||htmldb_item.text(2,b.filter_value) END
FROM all_tab_columns a,(select c001 column_name,c002 filter_value
from htmldb_collections where collection_name='P500_FILTERS') b
WHERE a.table_name = 'EMP'
and a.owner = 'X001'
and a.column_name=b.column_name(+)
Thanks in advance,
Suma.