Hello - (I will try to provide all of the relevant pieces of information, I apologize if this is too detailed.)
I am working with Oracle + Jasper Ireports to develop reports. The parent level report only returns a parameter of a project name from the user. The second level (first subreport) report returns data for any/all relevant artifacts to that project. There are six 'types' of data, so 6 slightly varied reports. The third level (second nested subreport) retrieves any/all associated comments for each of the artifacts. In the third query, I am trying to retrieve data from a CLOB and convert it to a string, this works with no issues. However, when I try to replace carriage returns/line feeds within the string text, I receive a java heap memory issue. Does anyone have any suggestions on how to change the query to allow it to retrieve data? Note: I can run this third sub query on all projects and it works, it's only when it's being run based on parameters from the parent queries that it hangs. select DISTINCT com.id, com.date_created, sfeeuser.FULL_NAME, replace(dbms_lob.substr(com.description,1000,1),chr(13)||chr(10),' ') as "Description" from sfee.SFCOMMENT com, sfee.artifact art, sfee.sfuser sfeeuser where com.OBJECT_ID = art.id AND com.CREATED_BY_ID = sfeeuser.id ORDER BY com.date_created DESC; I want to thank you if you read the whole thing or if you have any suggestions, thank you very much for your time. Kate -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
