NO DATA FOUND error [message #413925] |
Sun, 19 July 2009 04:10  |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |

|
|
Hello Dears!
What might be the cause of the error message "ORA-01403 no data found" from the following command:
SELECT NVL(MAX(NVL(sal,0)),0) INTO sal_var
FROM salary
WHERE slno<=slno_var+1 AND desig='MGR';
When I type the command at SQL> prompt then I get a numeric value 15, but when I run the command in PL/SQL in Forms Developer it says, "ORA-01403 no data found".
Thanks in advance for kind attention, please.
Best regards.
G. Hossain.
[The first two messages have been split from a hijacked topic. It also might need to be moved into the Forms forum.]
[Updated on: Sun, 19 July 2009 06:49] by Moderator Report message to a moderator
|
|
|
Re: Procedure [message #413926 is a reply to message #413925] |
Sun, 19 July 2009 04:13  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
What is your opinion?
What can be the cause of "no data found"?
Regards
Michel
|
|
|