|Fetching based on view [message #571440]
|Mon, 26 November 2012 01:04
Registered: August 2006
I have a scenario.
I have to create a master detail form where user has to input data for master table and then detail table.
When I have created a master detail form based on table , then its inserting data properly in same screen.
Same thing I want to create on view. Created a view on master table and created view on detail table. This is the requirement. I have to create master detail form based on views. Because I have to write instead of trigger on views to insert in temporary table for authorization. I have created master detail view based on views. But when I am clicking CREATE button after entering required inputs its showing as
ORA-01403: no data found
Unable to fetch row.
Return to application.
Its not storing data. So whether can we create a master detail report based on views. I think we can but I am getting the above error, so not sure where I am doing wrong. Can you please help on this.
[Updated on: Mon, 26 November 2012 01:04]
Report message to a moderator