Stored Procedure in Framework Manager - Update SP

[daffodilsss]

Hi,

I have an UPDATE sp written in Oracle 10g with two input paramters: Number and Varchar

The table that is getting updated has a size VARCHAR(500)and Number(2)

When I import the stored procedure into framework manager, COGNOS reportnet maps the VARACHAR datatype to CHARACTERLENGTH16.

I need the CHARACTERLENGTH16 to hold a message of length 200 characters. How could I increase the size of the CHARACTERLENGTH16 that is available in framework manager.

Many thanks!
Mani

 

[blom0344]

You need to check the precision, not the datatype.
My bet is that the precision is set to the proper length!

Ties Blom