I do not have any experience in Oracle. I usually send my data into Access but this app needs to go into Oracle. I have an Oracle procedure that I send my variables from an ASP form. My form has 7 variables and I sent just two to see if it works and it does. The code attached works with a procedure.
The problem I have is that I will need to attach to an Oracle package instead. The DBA has taken the working procedure and put it in a package.
The package name is testasp2.insert_name.
I have 2 inputs: stvlendcode & stvlenddesc
I have 1 output: p_result
Set Conn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = Conn
cmd.CommandType = 4
cmd.CommandText = "insert_name"
Set puser = cmd.CreateParameter("stvlendcode", 200, 1, 10, xusername)
Set ppass = cmd.CreateParameter("stvlenddesc", 200, 1, 30, xpassword)