Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

Cognos 8 Framework Manager -- Unable to View the Result Set of a Stored Procedure

If the result set of a stored procedure contains a CLOB (character large object) or BLOB (binary large object), you must modify the stored procedure before running it.
Steps to Use CLOBs

1. Create a model query subject that references the stored procedure.
2. Insert a Cast or Substring function to calculate a string based on the CLOB.

Steps to Use BLOBs

1. Create a model query subject that references the stored procedure.
2. Remove the BLOB from the Select statement of the query subject.
3. Add query items to the Select statement that perform a lookup on the table that contains the BLOB data.