Home » Developer & Programmer » Forms » Ora-01403 error
Ora-01403 error [message #467699] Mon, 26 July 2010 14:50 Go to next message
Amar_bu
Messages: 32
Registered: July 2010
Location: riyadh
Member
I have sort button that have the following code
go_block('TEL_OTHER_INFO');
set_block_property('TEL_OTHER_INFO',order_by,:system.cursor_item);
execute_query;

I have in the same form display item that its value will be sitting according to the post trigger of the previous text field

when i press the sort button i get frm-40735 post-text-item unhandled exception Ora-01403 error

Any suggestion

Report message to a moderator

Re: Ora-01403 error [message #467705 is a reply to message #467699] Mon, 26 July 2010 15:19 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORA-01403 means "no data found". So, make sure the POST-TEXT-ITEM returns something (or handle the exception).

Report message to a moderator

Re: Ora-01403 error [message #468021 is a reply to message #467705] Wed, 28 July 2010 11:17 Go to previous message
Amar_bu
Messages: 32
Registered: July 2010
Location: riyadh
Member
Thanks i solve it by puting te code in the post query trigger.

Report message to a moderator

Previous Topic: icon in window title bar
Next Topic: Error in view
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 21:42:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.