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.