Print Page | Close Window

how to use stored function in asp

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=24151
Printed Date: 29 March 2026 at 12:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: how to use stored function in asp
Posted By: maneeshkrverma
Subject: how to use stored function in asp
Date Posted: 12 August 2007 at 1:39pm

hi all Smile

i hav created a function in oracle 9i. like

create or replace function selrec(un varchar2, pass varchar2) return number is
begin
 select 'x' from user_info where id=un and pass=pass;

 return 1;
exception
 when no_data_found then
 return 0;
end;
/

now how should i use this function in asp to move the user to another page after login if the user is registered user.

thanx in advance
maneesh




Replies:
Posted By: michael
Date Posted: 20 August 2007 at 3:24pm
just call the function in an open recordset.


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net