Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure in Framework Manager - Update SP

Status
Not open for further replies.
daffodilsss

daffodilsss

Programmer
Apr 13, 2006
4
US
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
 
Sort by date Sort by votes
You need to check the precision, not the datatype.
My bet is that the precision is set to the proper length!

Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Emperatriz Stredel
  • Locked
  • Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
157
Emperatriz Stredel
Emperatriz Stredel
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
174
tushargaurav
tushargaurav
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
144
Goutham3835
Goutham3835
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
142
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
150
wwconslt
wwconslt

Part and Inventory Search

Sponsor

Back
Top