OraFAQ Forum: Reports & Discoverer » clob in report 6i (split from hijacked thread about problem with varchar2 declaration)

Home » Developer & Programmer » Reports & Discoverer » clob in report 6i (split from hijacked thread about problem with varchar2 declaration)

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

clob in report 6i (split from hijacked thread about problem with varchar2 declaration) [message #512964]

Thu, 23 June 2011 02:00

aryanna
Messages: 43
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;

Report message to a moderator

Re: Problem with Varchar2 declaration [message #512991 is a reply to message #512964]

Thu, 23 June 2011 03:20

cookiemonster
Messages: 9169
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have tried changing the return type of the function to clob?

Report message to a moderator

Re: Problem with Varchar2 declaration [message #513070 is a reply to message #512964]

Thu, 23 June 2011 08:06

joy_division
Messages: 4267
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.

Report message to a moderator

Re: Problem with Varchar2 declaration [message #513074 is a reply to message #513070]

Thu, 23 June 2011 08:10

cookiemonster
Messages: 9169
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.

Report message to a moderator

Previous Topic:	decode with reports
Next Topic:	TAB delimiter report is not functioning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 23:31:01 CDT 2013

Total time taken to generate the page: 0.06772 seconds