| clob in report 6i (split from hijacked thread about problem with varchar2 declaration) [message #512964] |
Thu, 23 June 2011 02:00  |
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;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
