ASP.NET Discussion - how to use stored function in asp

Print Page | Close Window

how to use stored function in asp

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24154
Printed Date: 29 March 2026 at 4:23am
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:43pm

hi all

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: Dilipv
Date Posted: 13 February 2008 at 10:10am

hi there,

i saw your quote. so why don't you use response.redirect method.
as soon as the user logs in, if condition will check the values in database. and if the condition is true then response.direct the user to the desired page.

Hope this will solve your query.

Thank you
jitesh
Programmer

-------------
http://www.intelcs.com/ - .Net Consulting

Posted By: emily12
Date Posted: 17 September 2008 at 8:17am

I'm new to asp.net and I have an oracle stored function with 3 input parameters that returns a string. The function is one that validates a user. I want to validate my users from Oracle. I'm trying to use the sqldatasource component to interact with my stored procedure but I can't seem to find the right syntax.

-------------
http://www.webdesigningcompany.net/ - design a website
http://freetemplates.webdesigningcompany.net/ - free templates

Posted By: jamie.townsend
Date Posted: 17 September 2008 at 9:31am

check this out:

http://www.oracle.com/technology/tech/dotnet/aspnet/index.html - http://www.oracle.com/technology/tech/dotnet/aspnet/index.html

an example:

http://www.c-sharpcorner.com/UploadFile/john_charles/CallingOraclestoredproceduresfromMicrosoftdotNET06222007142805PM/CallingOraclestoredproceduresfromMicrosoftdotNET.aspx - http://www.c-sharpcorner.com/UploadFile/john_charles/CallingOraclestoredproceduresfromMicrosoftdotNET06222007142805PM/CallingOraclestoredproceduresfromMicrosoftdotNET.aspx

Posted By: vikas
Date Posted: 17 February 2009 at 9:43am

I know how to call the stored procedure from asp..And the code is:


<%Dim 
                objConn, sqlInsName, FName, LName

                FName = "Benny"

                LName = "Alexander"

                set objConn = Server.CreateObject("ADODB.Connection")

                objConn.Open "DSN=macdb;uid=test;pwd=test" 

                sqlInsName = "sp_InsName '" & FName & "', 
                '" & LName & "'"

                objConn.Execute(sqlInsName) %>

but i am not sure about that the code will useful for you..I just wanted to help you out that's why i typed the code..

-------------
http://www.webdesigningcompany.net/" rel="no follow - Web design
Web Design New Yk

Posted By: SNK111
Date Posted: 14 July 2010 at 6:41am

Check this article http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html" rel="nofollow - HOW TO: SQL in JAVA & C# for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.