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 to [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)


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") 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
      set otb = nothing
      set oConn = nothing





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.