Home » Developer & Programmer » Application Express & MOD_PLSQL » Using the same page for update and insert (APEX 4.2, Oracle 11g)
Using the same page for update and insert [message #578293] Tue, 26 February 2013 10:56 Go to next message
inka
Messages: 14
Registered: February 2013
Junior Member
Hello All,

I have a page that was created by using an interactive report. The report lists values and these values are links. When I click on the link it takes me to the page where the data is displayed for the particular item. The report page also has a button that alow the user to enter new item. However, when I click on that button I get an error message:

ORA-01403: no data found

I am using APEX 4.2 and Oracle 11g.

How can I fix it?



Re: Using the same page for update and insert [message #578296 is a reply to message #578293] Tue, 26 February 2013 11:27 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This error means there is nothing for the criteria you gave.

Regards
Michel

[Updated on: Tue, 26 February 2013 13:04]

Report message to a moderator

Re: Using the same page for update and insert [message #578300 is a reply to message #578296] Tue, 26 February 2013 12:59 Go to previous messageGo to next message
inka
Messages: 14
Registered: February 2013
Junior Member
I am not sure what you mean.
Re: Using the same page for update and insert [message #578302 is a reply to message #578300] Tue, 26 February 2013 13:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry there was a missing word (I fix it).
I meant when you have this error this means the underlying query returns nothing, there is no rows matching the criteria you gave in your page.

Regards
Michel
Re: Using the same page for update and insert [message #578303 is a reply to message #578302] Tue, 26 February 2013 13:09 Go to previous messageGo to next message
inka
Messages: 14
Registered: February 2013
Junior Member
When I click the Add New Record button I don't want to run a query, I want to be able to enter data.
Re: Using the same page for update and insert [message #578308 is a reply to message #578303] Tue, 26 February 2013 14:27 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which page returns that error? Is it interactive report or a form?
Re: Using the same page for update and insert [message #578309 is a reply to message #578308] Tue, 26 February 2013 14:38 Go to previous messageGo to next message
inka
Messages: 14
Registered: February 2013
Junior Member
Form
Re: Using the same page for update and insert [message #578345 is a reply to message #578309] Wed, 27 February 2013 03:02 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK then; open the form page in the builder and check processes, on load dynamic actions, anything that could fire upon loading the page and that is capable of raising the error.
Re: Using the same page for update and insert [message #581293 is a reply to message #578309] Thu, 04 April 2013 04:42 Go to previous message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
most likely, there is a process which is getting executed 'on load' of the page, this process is having a SELECT query which returns this error.

regards,
Delna
Previous Topic: Do not use an external authentication scheme
Next Topic: Display report based on the value picked from select list
Goto Forum:
  


Current Time: Sat Aug 30 07:30:20 CDT 2014

Total time taken to generate the page: 0.09506 seconds