Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When validating a report I get a Clob/Blob data error?

April 26, 2017blob CLOB Data Error report validating

0

Posted

When validating a report I get a Clob/Blob data error?

1 Answer

0

Posted

When validating a report I get the following error: Using the blob/clob column…in this query, requires that the query subject must have either a key or a unique index. This means that one of the query items in the report has a Data Type of Blob or Text Blob. You can see this by looking at the table or view in Framework Manager. Clob and Blob data types are not supported by ReportNet. If this is a query item that you require you can contact the IRTHelp@stthomas.edu with a request to have the data type changed in Oracle. Otherwise you can create a new namespace with the view or table eliminating the query item with the Blob/Clob data type.