My Oracle Support Banner

Testing Value Of Numeric Field In ASP Fails With '0x800A000D' (Doc ID 263606.1)

Last updated on NOVEMBER 29, 2019

Applies to:

Oracle Provider for OLE DB - Version 8.1.7.0 to 9.2.0.4 [Release 8.1.7 to 9.2]
z*OBSOLETE: Microsoft Windows 2000
z*OBSOLETE: Microsoft Windows XP
z*OBSOLETE: Microsoft Windows Server 2003
Microsoft Windows (32-bit)

Symptoms

Testing a numeric value for equality within ASP fails with the error: 

Microsoft VBScript runtime error:  '0x800A000D'
Type mismatch



An example of ASP code that demonstrates this error follows:

<% 
      option explicit
      dim cCon,oConn,cSQL,oTb
      cCon = "Provider=OraOLEDB.Oracle.1;User ID=scott;password=tiger;Data Source=v92;Persist Security Info=False"
      set oConn = server.createobject("ADODB.connection")
      oConn.open cCon
      cSQL = "select numcol from mynumbertest"
      set otb = oconn.execute(csql)
      if not otb.eof then
            if otb("numcol") = 1 then response.write "Value is 1"
      end if
      otb.close
      set otb = nothing
      oConn.Close
      set oConn = nothing
%>

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.