Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Returning and using CLOB data

Status
Not open for further replies.

rjp001

Technical User
Oct 13, 2005
2
US
I have data stored in a CLOB field in my database. I've been using Actuate 7, and I can use my SQL statement to return the data using dbms_lob.substr(fieldname, 3000, 1) and Actuate returns the data as datatype RAW(2000). I can then assign the text type on the Actuate control to display as HTMLtext to use it in my report. The same SQL statement works in SQL Server Reporting, but when I try to use the data from the CLOB I get the error: "[rsInvalidExpressionDataType] The Value expression used in textbox ‘textbox28’ returned a data type that is not valid." Using SQL Server Reporting, is there any method to assign to Text Type to see the data as HTML text within my report?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top