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
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh

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: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your opinion?
What can be the cause of "no data found"?

Previous Topic: File separator creates problem
Next Topic: Oracle Convert number to asterisk
Goto Forum:

Current Time: Fri Jul 21 17:57:03 CDT 2017

Total time taken to generate the page: 0.18177 seconds