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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
