Outsystems and Oracle Views

Outsystems and Oracle Views

  
Hi, I've been having trouble changing data in my Oracle Views, getting a message back from it saying "ORA-01733: virtual column not allowed here." The way I tried to add a record was with the Create(View Name) function provided. It seems it wants me to edit the base table rather then the view. Has anyone delt with issue before or have any idea as to how to work around this? Thanks
Hi Luka,

That error means that your view has calculated columns in it's definition, so creates/upgrades are not allowed by the database over the view.
To be able to use the Create / Upgrade actions your view needs be updatable.
Here is a link for the oracle documentation: http://docs.oracle.com/cd/B28359_01/server.111/b28310/views001.htm#ADMIN11782

Regards,
João Rosado