Oracle, numbers, 810, what to do?

John T. Hunter jthunter@nbnet.nb.ca
Thu, 7 Sep 2000 11:58:12 -0300


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.