how to insert data into different views through oracle forms

[gauravdua]

hello

plz tell me how can i insert data into different views throgh oracle forms.
actually i had made form on purchase order using
po_headers_v
po_distributions_v
po_lines_v

it execute properly, but when i try to insert new data into it
it's gives error "cannot modify a column which maps to a non key-preserved table".

i am fresher to forms .plz guide me properly with steps

[debasisdas]

why don't you insert directly into the base table.

[amitpatel66]

Hi Gaurav,

Welcome to TSDN!!

Please make sure you follow POSTING GUIDELINES when ever you post in this forum

Thanks
MODERATOR

[gauravdua]

why don't you insert directly into the base table.

bcoz in all oracle standard forms,they always use views to insert or execute query
for example look any standard form from resources and see property pallete of any data block in this "query_data_source_name " always view

[amitpatel66]

bcoz in all oracle standard forms,they always use views to insert or execute query
for example look any standard form from resources and see property pallete of any data block in this "query_data_source_name " always view

Hi Gaurav,

You need not go with what is the functionality in standard form. This is your customized form if I am not wrong, so you can implement your way and make use of base table instead of inserting in to a view.