Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: josephsiah
- Order by date
-
type mismatch error: asp and oracle stored procedure using parameters
Here is another thing that I notice: When I remove the call to the stored procedure and have a line like this, objCmd_lb.CommandText = "" I still receive the type mismatch error. Could it be my connection to the database or stored procedure?- josephsiah
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
type mismatch error: asp and oracle stored procedure using parameters
Yes. The ado constants are in the adovbs.inc file. I have a line on the page as follows: <!-- #include virtual="/assets/inc/adovbs.asp" --> <% Dim strFieldValue Dim dicFields 'dictionary for failed fields Dim blnFieldIsOkay- josephsiah
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
type mismatch error: asp and oracle stored procedure using parameters
This line produces the error: objCmd_lb.Parameters.Append = objCmd_lb.CreateParameter("V_HIN", adVarChar, adParamInput, txtHin) When I comment out the line, the error moves to the next line. Also, I have tried it out with the following code and I still get the same error message...- josephsiah
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
type mismatch error: asp and oracle stored procedure using parameters
Can someone please help me with the following code? I am getting the following error message: Error Type: Provider (0x80020005) Type mismatch. ASP CODE: Dim objCmd_lb Dim txtHin, txtYearBuilt, txtCertNumber, v_PassFormatCheck txtHin = Request.Form("txtHIN") txtYearBuilt...- josephsiah
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
