Home » Developer & Programmer » Forms » Pass a message From PLSQL Procedure To Forms (D2k) (PLSQL,Forms 6i)
Pass a message From PLSQL Procedure To Forms (D2k) [message #290563] Sat, 29 December 2007 23:25 Go to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

Hello Friends,
Actually I want to pass a message From PLSQL Procedure To Forms application, But Raise application Failure Trigger we cannot use.
Just i want to display a msg ( Alert).
How to do that..
Eg. "No Employees Found..." Like that it should display...if No Data Found In that PLSQL Procedure.....


Regards,
Kalyan
Re: Pass a message From PLSQL Procedure To Forms (D2k) [message #290574 is a reply to message #290563] Sun, 30 December 2007 00:20 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Are you allowed to change the procedure code?

I have two suggestions. But each one has limitations.

1. Don't handle NO_DATA_FOUND in the procedure and handle it in the form. But you need to change all the calling procedures.

2. Add an OUT parameter and pass "No Employees Found..." when you get NO_DATA_FOUND exception. Here also you need to change all the calling procedures.

By
Vamsi
Previous Topic: Running Forms (10g)
Next Topic: How to set database values to list item on execute query?
Goto Forum:
  


Current Time: Fri Dec 09 21:01:03 CST 2016

Total time taken to generate the page: 0.30564 seconds