Home » SQL & PL/SQL » SQL & PL/SQL » NO DATA FOUND error
NO DATA FOUND error [message #413925] Sun, 19 July 2009 04:10 Go to next message
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 Go to previous message
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
Previous Topic: File separator creates problem
Next Topic: Oracle Convert number to asterisk
Goto Forum:
  


Current Time: Sat Feb 08 17:43:34 CST 2025