| Pass a message From PLSQL Procedure To Forms (D2k) [message #290563] |
Sat, 29 December 2007 23:25  |
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  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
