|
Re: Stored Procedures In ASP [message #11020 is a reply to message #11005] |
Mon, 01 March 2004 06:57 |
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
|
|
|