ORA-01733: virtual column not allowed here
Posted on 2001-07-25
I try something rather simple and are stunned that this doesn't work.
Here is a quick test setup:
Create a table called cm_test with one column (varchar2) and call it "Another Test".
Then create a view like this:
select 'Another Test' as Another_Test from cm_test
This works perfectly till trying to update this view in anyway (update/insert/delete), where I get the error stated (ORA-01733: virtual column not allowed here). I understand that I can't insert values into a view that uses "calculated" fields, but this mapps 1 to 1 back to the table. Taking the space out of the table column name solves (obviously) the problem, but that is not a option for me as I have to work with 3rd party tables. Is there any way to persuede Oracle to do what I want?