Home » Developer & Programmer » Reports & Discoverer » Function Returning CLOB (Oracle 9i)
Function Returning CLOB [message #330398] Mon, 30 June 2008 01:26 Go to next message
garimella.aditya
Messages: 2
Registered: June 2008
Location: Mumbai
Junior Member
Hi All,

I am creating a Database function which returns a CLOB and when I call it in sql statement and converting using to_char I can only see 4000 characters and my clob returns more than 5000+ characters. how can i solve this I want to display entire text in sql and that too in character string only...
as I am using this function in a report builder I want convert the CLOB to varchar...

regards,
aditya.

Report message to a moderator

Re: Function Returning CLOB [message #330399 is a reply to message #330398] Mon, 30 June 2008 01:28 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
I haven't used Reports is quite a while, but isn't Reports capable of handling CLOBs? Is it necessary to convert it to a varchar2?

Report message to a moderator

Re: Function Returning CLOB [message #330402 is a reply to message #330399] Mon, 30 June 2008 01:44 Go to previous message
garimella.aditya
Messages: 2
Registered: June 2008
Location: Mumbai
Junior Member
hi frank,

Yaa I accept but in my reports I have attached a html file to the paper layout and sending the function output to the html file. so, I cant use the CLOB datatype.

regards,
aditya.

Report message to a moderator

Previous Topic: Print dialog problem in report 6i
Next Topic: Excluding zero having records in report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 16:24:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.