OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Using the same page for update and insert

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Using the same page for update and insert (APEX 4.2, Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using the same page for update and insert [message #578293]

Tue, 26 February 2013 10:56

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?

Report message to a moderator

Re: Using the same page for update and insert [message #578296 is a reply to message #578293]

Tue, 26 February 2013 11:27

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

inka
Messages: 14
Registered: February 2013

Junior Member

I am not sure what you mean.

Report message to a moderator

Re: Using the same page for update and insert [message #578302 is a reply to message #578300]

Tue, 26 February 2013 13:05

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Using the same page for update and insert [message #578303 is a reply to message #578302]

Tue, 26 February 2013 13:09

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.

Report message to a moderator

Re: Using the same page for update and insert [message #578308 is a reply to message #578303]

Tue, 26 February 2013 14:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Which page returns that error? Is it interactive report or a form?

Report message to a moderator

Re: Using the same page for update and insert [message #578309 is a reply to message #578308]

Tue, 26 February 2013 14:38

inka
Messages: 14
Registered: February 2013

Junior Member

Form

Report message to a moderator

Re: Using the same page for update and insert [message #578345 is a reply to message #578309]

Wed, 27 February 2013 03:02

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Using the same page for update and insert [message #581293 is a reply to message #578309]

Thu, 04 April 2013 04:42

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 02 12:57:36 CST 2025