Home » SQL & PL/SQL » SQL & PL/SQL » Stored Procedures In ASP
Stored Procedures In ASP [message #11005] Mon, 01 March 2004 00:01 Go to next message
Piyush Tripathi
Messages: 1
Registered: March 2004
Junior Member
How can i call a stored procedure from an ASP Page?? Please explain it by giving an example.
Re: Stored Procedures In ASP [message #11020 is a reply to message #11005] Mon, 01 March 2004 06:57 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
You are in wrong forum boy .

SET OBJCONN = SERVER.CREATEOBJECT("ADODB.CONNECTION")
OBJCONN.OPEN "Provider=MSDAORA; Data Source=RRR;User ID=udb;Password=aajam"

set cmd = Server.CreateObject("ADODB.Command")
set cmd.ActiveConnection = objConn

cmd.CommandText = "proc_memphistn"

cmd.CommandType = adCmdStoredProc

'Create Input parameters for Stored Procedure
'proc_memphistn(p_sdate varchar2,p_edate varchar2,p_region varchar2)

set param1 = cmd.CreateParameter("m_sdate", adchar, adParamInput,10)
cmd.Parameters.Append param1
cmd.Parameters("m_sdate") = startdate

set param2 = cmd.CreateParameter("m_edate", adchar, adParamInput,10)
cmd.Parameters.Append param2
cmd.Parameters("m_edate") = enddate

set param3 = cmd.CreateParameter("m_region", adchar, adParamInput,10)
cmd.Parameters.Append param3
cmd.Parameters("m_region") = region

'exec proc_memphistn('01/10/2003','31/10/200', 'SESR')
cmd.execute

check on asp101.com and other asp sited
Previous Topic: displaying dates between two dates
Next Topic: DECODE - need an alias NAME.
Goto Forum:
  


Current Time: Fri Mar 29 03:49:44 CDT 2024