| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Regarding Stored Procedures |
|
From: |
Ramesh |
|
Date: |
6/2/2000 2:32:39 PM |
|
IP: |
202.9.171.62 |
While accessing backend stored procedure of oracle from asp, it is giving an error like wrong number of arguements,or the arguements are in conflict with each other, etc. We tried the following syntax,
dim Con
dim MyCommand
dim MyParam1
dim MyParam2
DIM LNGRC
set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "Provider=MSDAORA.1;User ID=trading;password=trd;Data Source=ora;"
myCommand = Server.CreateObject("ADODB.Command" )
MyCommand.ActiveConnection = Con
MyCommand.CommandType = 4
MyCommand.CommandText = "call GET_SESSIONID"
set MyParam1 = MyCommand.CreateParameter("user_id",advarchar,adParamInput,"6")
set MyParam2 = MyCommand.CreateParameter("session_id1",adNumeric,adParamOutput,6)
MyCommand.Parameters.Append MyParam1
MyCommand.Parameters.Append MyParam2
MyCommand.Execute
We did not get the solution, Please inform my mail id with the correct syntax or solution to the above.
|
Follow Up - Re: Regarding Stored Procedures - umesh 9/14/2000 10:35:36 AM
|
|
|
|
|
|
