Need help creating an updatable view

Good day,

I'm have a bit of difficulty with a view that I created for one of my tables.

create or replace view v_comms as

select "Comm ID" as comm_id,


       "Contact ID" as contact_id,

       "Project Lead ID" as lead_id,

       "Topic" as topic,

       "Entry Date" as date_entry,

       "Entry By" as user_entry,

       "Modified Date" as date_modified,

       "Modified By" as user_modified,

       "Notes" as notes

  from comms

This view is designed to convert mixed-case column names into valid
Oracle column names. Otherwise, the view has the exact same columns as
the original table.

If I attempt to update a column in this view, namely the notes column
which is a LONG, I get the following error:

ORA-01732: data manipulation operation not legal on this view

The querying the user_updatable_columns for this view show me that all are updatable.

My problem stems from the fact the the front end tools that I am currently using to access this table will not recognize mixed case columns.

Can somebody tell me what I'm missing here? A pointer to the documentation that describes this behaviour would work for me.

Thanks in advance.

-- 
Ken Rachynski <krachyn_at_evansconsoles.com>
Database Analyst/Unix Administrator/Internet Administrator
EVANS
Calgary, Alberta, Canada
Direct: 403-717-3080
Main:   403-291-4444
Fax:    403-250-6549
http://evansonline.com/