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.
Showing posts with label Unable to View the Result Set of a Stored Procedure. Show all posts
Showing posts with label Unable to View the Result Set of a Stored Procedure. Show all posts
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.
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.
Subscribe to:
Posts (Atom)