Oracle, numbers, 810, what to do?

[Hasse, Christina]

Hi John,

I would try identifying the columns in the dictionary as elements with a
size you determine and see if they work then.

> Regards,
> 
> Christina Hasse
> ADT North American Services Manager
> COGNOS CORPORATION
> christina.hasse@cognos.com
> 
> Office: 847 - 598 - 2300
> Cell: 847 - 612 - 6854
> 
> Mark Your Calendar!
> enterprise2000
> Cognos User Conference, October 2-5, Anaheim, California
> http://www.cognos.com/enterprise2000
> 
> 
> 


-----Original Message-----
From: John T. Hunter [mailto:jthunter@nbnet.nb.ca]
Sent: Thursday, September 07, 2000 9:58 AM
To: powerh-l@sphere.swau.edu
Subject: Oracle, numbers, 810, what to do?


Hey Gang,

We have an Oracle database (7.3) where most numeric 
elements are defined as number * (ie no size given).

Using Powerhouse 810 the element shows as 
PACKED SIGNED  20 

Other numeric elements that have a size (eg. 12) show as
INTEGER SIGNED     8      (these seem to work fine)

A simple quiz report on the unsized elements produce
data conversion errors.

So as it stands we cannot choose, select, or report any of these
elements.

What have others done here?  Are there any easy workarounds?
We cannot change our Oracle database because it's a canned package.

Thanks for your help,
-John


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.