OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Filter not working (Apex 4.0,win8,Oracle 10g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Filter not working [message #627488]

Wed, 12 November 2014 06:00

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Hello,

I have one function which return CLOB variable that contains string and It displayed in interactive report, Data is shown properly but the filter on column is not working. what is the reason behind this problem function return CLOB variable.

My function looking like:-

create or replace FUNCTION  dummy
(a in NUMBER, b NUMBER)
return VARCHAR2
is
  l_temp varchar2(32767);  
begin
  l_temp  := '';
  for i in
      (select col1,col2
         from table1
         where col1 =a
         and col2 = b)
  loop
    l_temp   := l_temp  || i.col1 || ' (ID ' || i.col2 || '), ';
  end loop;
  return l_temp  ;
end;

Thanks,
Xandot

Report message to a moderator

Re: Filter not working [message #627493 is a reply to message #627488]

Wed, 12 November 2014 06:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Where is that function? This one returns VARCHAR2, not CLOB.

Report message to a moderator

Re: Filter not working [message #627494 is a reply to message #627493]

Wed, 12 November 2014 06:49

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

I Apologies for wrong function.Below is the correct function:-

create or replace FUNCTION  dummy
(a in NUMBER, b NUMBER)
return clob
is
  l_temp clob;  
begin
  l_temp  := '';
  for i in
      (select col1,col2
         from table1
         where col1 =a
         and col2 = b)
  loop
    l_temp   := l_temp  || i.col1 || ' (ID ' || i.col2 || '), ';
  end loop;
  return l_temp  ;
end;

Report message to a moderator