Oracle Forms

Currently I created this screen, there is no problems on display data, only on the update funtionality (it means insert / update / delete on the table for which the view is based on).

I have a table and a complex view in order to display the information from the table in a tabellar form (i.e up to 70 record in same "record" in the form, one for each item)

The view is like this



select a.f1, a.f2, get_value(a.pk1,1) a1, get_value(a.pk1,2) a2, get_value(a.pk1,3) a3............

from my_table a

where a.proj_id = user





and I want to permit the update of the field a1, a2, a3 in a multiposition canvas (tabellar).

I created an INSTEAD-OF trigger.

But it not work only in the form. I receive the error FRM-40654 when I try to change the existing value in the running form based on that view.

The view is woking and updatable using sql-plus.

If I query
select * from ALL_UPDATABLE_COLUMNS where table_name = 'SPV_BOQ_BOM_POS_ACTIVITIES';

in which 'SPV_BOQ_BOM_POS_ACTIVITIES' is the name of my view.

The question is: why if the view is updatable using SQL*Plus, is not updatable using Oracle Form 10gR2 ?

Someone could help me asap?

Thanks