meenakshidhar
Programmer
Hi All,
I want to call oracle procedure from my ASP page in which i m passing the value of empno and want to display empname,job etc..from the table...my code is given below...
=========================================================
Dim strSearchName
Dim objConnection
Dim objCommand
Dim objRecordset
strSearchName = 7369
Set objConnection = Server.CreateObject("ADODB.Connection")
With objConnection
.ConnectionString = "Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=INDV;Persist Security Info=True"
.Open
End With
Set objCommand = Server.CreateObject("ADODB.Command")
With objCommand
Set .ActiveConnection = objConnection
.CommandText = "{call proc_meenu1(" & _
"?, {resultset 100, empno})}"
.CommandType = 1
.Parameters(0).Value = strSearchName
Set objRecordset = .Execute()
End With
Response.Write objRecordset.Fields("EmpName")
Response.Write objRecordset.Fields("job")
=========================================================
urgent help needed...
Regards,
Meenakshi Dhar
I want to call oracle procedure from my ASP page in which i m passing the value of empno and want to display empname,job etc..from the table...my code is given below...
=========================================================
Dim strSearchName
Dim objConnection
Dim objCommand
Dim objRecordset
strSearchName = 7369
Set objConnection = Server.CreateObject("ADODB.Connection")
With objConnection
.ConnectionString = "Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=INDV;Persist Security Info=True"
.Open
End With
Set objCommand = Server.CreateObject("ADODB.Command")
With objCommand
Set .ActiveConnection = objConnection
.CommandText = "{call proc_meenu1(" & _
"?, {resultset 100, empno})}"
.CommandType = 1
.Parameters(0).Value = strSearchName
Set objRecordset = .Execute()
End With
Response.Write objRecordset.Fields("EmpName")
Response.Write objRecordset.Fields("job")
=========================================================
urgent help needed...
Regards,
Meenakshi Dhar