By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,634 Members | 1,898 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,634 IT Pros & Developers. It's quick & easy.

how to insert data into different views through oracle forms

P: 4
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
Jan 3 '08 #1
Share this Question
Share on Google+
4 Replies


debasisdas
Expert 5K+
P: 8,127
why don't you insert directly into the base table.
Jan 3 '08 #2

amitpatel66
Expert 100+
P: 2,367
Hi Gaurav,

Welcome to TSDN!!

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

Thanks
MODERATOR
Jan 3 '08 #3

P: 4
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
Jan 3 '08 #4

amitpatel66
Expert 100+
P: 2,367
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.
Jan 3 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.