Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

Cognos Framework Manager SPROC issue

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.