named notation with Oracle Stored Procedures from ASP???

PaulS · #1 (**permalink**) 11-03-03, 11:48

Is there anyway to pass/add parameters to Oracle Stored Procedures from an ASP page using the named notation rather than the order/number notation, i.e SPTest(TestID => 1,name => "Monkey")

Currently have following code

Code:

set objcommand = Server.CreateObject("ADODB.Command")
objcommand.ActiveConnection = objconn
objcommand.CommandType = 4
objcommand.CommandText = "spTest"
		
Set oParamAdd = objcommand.Parameters
		
oParamAdd.Append objcommand.CreateParameter("pName",129,&H0001)
objcommand("pName") = "blarblarblar"	
		
objcommand.Execute

If pName is not the first parameter declared in the store Procedure then it falls over.

If anyone can help me use the named notation that would be great.

Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech