Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Fetching based on view (APEX4.2)
Fetching based on view [message #571440] Mon, 26 November 2012 01:04
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
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

Previous Topic: APEX materials
Next Topic: Getting error webpage cannot be found with apex listner
Goto Forum:
  


Current Time: Thu Mar 28 16:59:24 CDT 2024