Just wondered if anyone had come accross this one .....
We've removed the maitenance of a table to an Oracle view, so we have our PRO-IV file definition linking to it via the alternate file name. E.g.
File: FILE1
Alternate: FILE1_V
Where FILE1_V is the view.
In the selection logic within a function, if we do a
SELECT FROM FILE1 WHERE (conditions) etc it will merrily retrieve all the records from the view,
but SELECT F.* FROM FILE1 F, FILE2 X (join statements) (conditions) etc etc
you get
366 - SQL ERROR:
ORA-00942: table or view does not exist
We know how to fix it (just reference the alternate file name (FILE1_V) in the embedded SQL) but just thought I'd share it with the PRO-IV Massive
PRO-IV Version: 5.0000 Release 1.0.9
