Re: Weired: ORA-904 (invalid column name)

Gary Myers wrote:
>
> Have you tried going throutgh the tables record by record in a cursor.
> Or an EXPORT/IMPORT ? Those might show where the problem lies ?
> What are the datatypes/sizes of the columns ?
> gary

I tried EXPORT/IMPORT (there I discovered the problem): While exporting the error message occurs, but in the import only the table structure is then imported (without data). Then queries are possible on that table (without errors).

I didn't try browsing with a cursor (yet).

Best regards,
 friedel

-- 
    Friedel Hosenfeld         http://www.pz-oekosys.uni-kiel.de/~friedel
Ecosystem Research Centre            friedel_at_pz-oekosys.uni-kiel.d400.de
 Schauenburger Str. 112		          
  D-24118 Kiel *  FRG                         blue in the face?