| showing oracle messages in asp [message #76199] |
Sat, 06 October 2001 23:12  |
Amit
Messages: 166
Registered: February 1999
|
Senior Member |
|
|
hello sir/mam
i have to call this package from asp
In the third select statement i have to generate an message in the exception no_data_found , telling user something
how do i show this message in asp
regards
amit
PACKAGE BODY Process_Enrollments IS
PROCEDURE Enroll_Student
(
a NUMBER;
b NUMBER;
c NUMBER;
)
BEGIN
select col into a from userpass;
select pass into b from userpass1;
begin
select coll into c from userpass2
where name = 'amit'
exception
WHEN NO_DATA_FOUND THEN
-- here i have to populate a msg to
inform the user somehing something
end;
END Enroll_Student;
END Process_Enrollments;
----------------------------------------------------------------------
|
|
|
|
| Re: showing oracle messages in asp [message #76205 is a reply to message #76199] |
Thu, 11 October 2001 14:09  |
Chris Albright
Messages: 2
Registered: October 2001
|
Junior Member |
|
|
You will have to either create this procedure as a function and return the message or create an out parameter as varchar2 and pass the message that way. If you are defining ADO parameters in ASP you will be able to get the value that way. Otherwise, if you are building the call dynamically like "enroll_student(" & numVal & "," & numVal2 & "," & numVal3 & ")" it won't work.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
