Home » Developer & Programmer » Forms » error capture (oracle IDS 10g,Windows Xp)
error capture [message #399267] Tue, 21 April 2009 06:33 Go to next message
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
Hi to all

I have created a login form.I enter the correct username and password ,then click the pushbutton it goes to next block.It works fine.I enter wrong username ,password doesnt go the next block.It works fine.There is a default error message dispaly like

FRM-40735:WHEN_BUTTON_PRESSED trigger raised unhandled exception ORA-01403

I write the following code



select username,password into  :block8.username,:block8.password from pim_log2
where username =:block8.username and password=:block8.password ;
if :block8.username =:block8.username and :block8.password=:block8.password  then
 message('Invalid username and password');
end if;

else part doesnot display.alternatively first mentioned default error message display.my question is enter the wrong username and password else part display

Send solution

thanks regards


[Updated on: Tue, 21 April 2009 06:37]

Report message to a moderator

Re: error capture [message #399277 is a reply to message #399267] Tue, 21 April 2009 06:56 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
NO-DATA-FOUND can not be captured in an IF-THEN-ELSE - you'll need to write an exception handling section to do that, such as
  select ...
    from ...
    where ...

  if ... then
  end if;

  when no_data_found then
Previous Topic: ORA-01445 on execute_query
Next Topic: Export to an pre-existing Excel file
Goto Forum:

Current Time: Thu Oct 20 19:48:14 CDT 2016

Total time taken to generate the page: 0.24303 seconds