Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » showing oracle messages in asp
showing oracle messages in asp [message #76199] Sat, 06 October 2001 23:12 Go to next message
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: Re: web server
Next Topic: URGENCY!!!!!!!!!Defragmentatation of a Oracle Tablespace
Goto Forum:
  


Current Time: Tue Jan 19 21:48:25 CST 2021