Home » Developer & Programmer » Reports & Discoverer » clob in report 6i (split from hijacked thread about problem with varchar2 declaration)
clob in report 6i (split from hijacked thread about problem with varchar2 declaration) [message #512964] Thu, 23 June 2011 02:00 Go to next message
aryanna
Messages: 44
Registered: July 2007
Member

Hi I having issue when i try to use CLOB as varchar2 is not enough in my case. I'm developing function column in oracle report. I'm using developer 6i. I get error function return must char?

How I can use CLOB in oracle report?

function CF_RnoFormula return Char is
--v_release_num CLOB;
v_release_num varchar2(32767);


begin

FOR rec IN
(SELECT release_num
FROM PO_RELEASES_all
WHERE po_header_id = :header_id
ORDER BY release_num)
LOOP
v_release_num := v_release_num || ',' || rec.release_num;
END LOOP;


RETURN LTRIM (v_release_num, ',');

return v_release_num;

end;
Re: Problem with Varchar2 declaration [message #512991 is a reply to message #512964] Thu, 23 June 2011 03:20 Go to previous messageGo to next message
cookiemonster
Messages: 10848
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have tried changing the return type of the function to clob?
Re: Problem with Varchar2 declaration [message #513070 is a reply to message #512964] Thu, 23 June 2011 08:06 Go to previous messageGo to next message
joy_division
Messages: 4489
Registered: February 2005
Location: East Coast USA
Senior Member
I could be way off base here, but Developer 6i is very old and I think I remember that it did not support CLOB.
Re: Problem with Varchar2 declaration [message #513074 is a reply to message #513070] Thu, 23 June 2011 08:10 Go to previous message
cookiemonster
Messages: 10848
Registered: September 2008
Location: Rainy Manchester
Senior Member
To be honest I suspected that as well. But if that's the case the change I suggested above should lead to an error message which will confirm it.
Previous Topic: decode with reports
Next Topic: TAB delimiter report is not functioning
Goto Forum:
  


Current Time: Tue Jul 29 06:13:14 CDT 2014

Total time taken to generate the page: 0.05880 seconds