How to return a BOOLEAN from Oracle
3632Sep 7 2003 — edited Sep 9 2003My application is written using borland delphi using MS SQL server 2000. There are a lot of hard codes which queries the db to return a BOOLEAN. We are trying to migrate SQL SErver to Oracle but it seems that Oracle does not have a boolean datatype. Therefore tons of code needs to be changed from the apps side. Any way of getting around this problem, so that changes need not be done in apps side.
thanks;
andrew