Data Type in A View

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Sat, 03 Aug 2002 20:18:19 -0800
Message-ID: <F001.004AAD21.20020803201819@fatcity.com>

We do a fair bit of development using the Remedy tools. One of those developers is using what is known as a view form. This device does not allow one to specify the data type, but gets it from the database. However if a field is declared thus, num1 number, the view form will treat it as an integer truncating the fractional portion.

The desire is to build one of these forms against a materialized view. The view is snapshotting a view on another database which consists of three fields. The employee id, the name of the employee and how many dollars of a certain type have been spent on the employee. The last field employs the aggregate function, sum. Oracle assigns the "number" data type to the field. The Remedy view form is interpreting it as an integer.

I thought, perhaps, I could prebuild the table and declare the field as number(6,2) and have the snapshot use that. However this results in, "ORA-12060: shape of prebuilt table does not match definition query."

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Aug 03 2002 - 23:18:19 CDT