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.
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: 7880
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?
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.
Previous Topic: Print dialog problem in report 6i
Next Topic: Excluding zero having records in report
Goto Forum:
  


Current Time: Sat Dec 03 06:09:13 CST 2016

Total time taken to generate the page: 0.17146 seconds