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.

 

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.

 

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.