Hi,
I just finished migration from MSSQL2K to Oracle 9.2.0.1.
I'm using ASP to access the database for information. After migration, all my comparison and calculations in ASP pages stopped working because of type mismatch. Apearantly, all integers that are migrated into Oracle are not integers any more. I had to use CINT(), which is a function in VB script to convert any other datatype data to integer, for my scripts to work. There're too many places in the entire web site. I cannot go through every single variable and add CINT() around it. Does anybody have any idea on why this happened and how to fix it?
If I query from SQL*PLUS, it returns me a number on the screen, but I'm not sure if it's a number or a character. I have checked the table definition, the data type for corresponding integers is NUMBER(10).
Thanks.
I just finished migration from MSSQL2K to Oracle 9.2.0.1.
I'm using ASP to access the database for information. After migration, all my comparison and calculations in ASP pages stopped working because of type mismatch. Apearantly, all integers that are migrated into Oracle are not integers any more. I had to use CINT(), which is a function in VB script to convert any other datatype data to integer, for my scripts to work. There're too many places in the entire web site. I cannot go through every single variable and add CINT() around it. Does anybody have any idea on why this happened and how to fix it?
If I query from SQL*PLUS, it returns me a number on the screen, but I'm not sure if it's a number or a character. I have checked the table definition, the data type for corresponding integers is NUMBER(10).
Thanks.
