Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading data in a CLOB from BIRT report

 
Shane W
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
We are using BIRT and I need to show data stored as a CLOB on a report.IF i just put the data fetched from the DB , it gives the CLOB object id.Need to show the actual data. How do i get the reader (or stream)to this clob in BIRT?

Shane
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't you just bind your clob to a text control and the ODA stuff just takes care of it?
 
Shane W
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All
The problem is now resolved.If I striaghtaway put the data fetched by the procedure on to the report, I used to get the id of the clob.The right way is to use the substring method on the clob object.
Had done it but had given the intial position as 0 instead of 1,hence was throwing illegal argument exception.
Eagle eyes of a colleague spotted the problem
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic