how to show oracle messages in asp

Results 1 to 2 of 2

Thread: how to show oracle messages in asp

  1. #1
    Join Date
    Dec 1969

    Default how to show oracle messages in asp

    hello sir/mam<BR>i have to call this package from asp <BR>In the third select statement i have to generate an message in the exception no_data_found , telling user something<BR>how do i show this message in asp <BR>regards <BR>amit<BR><BR>PACKAGE BODY Process_Enrollments IS<BR><BR>PROCEDURE Enroll_Student<BR>(<BR>a NUMBER;<BR>b NUMBER;<BR>c NUMBER;<BR>) <BR><BR>BEGIN<BR><BR>select col into a from userpass;<BR><BR>select pass into b from userpass1;<BR><BR>begin<BR>select coll into c from userpass2<BR>where name = &#039;amit&#039;<BR><BR>exception<BR><BR>WHEN NO_DATA_FOUND THEN<BR><BR>-- here i have to populate a msg to <BR>inform the user somehing something<BR>end;<BR><BR><BR>END Enroll_Student; <BR>END Process_Enrollments;<BR>

  2. #2
    Join Date
    Dec 1969

    Default Put message into an output parameter.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts