I have a problem with the application that issues a select distinct count of a column that has NULLS value on Oracle 10.1.0.4. The application doesn't handle the warning message returned and shuts down. I cannot change the application code… neither to recompile. Is there a way to suppress the warning messages so the application will not stop?
Below is the exact statement that causes the problem, but I cannot reproduce it in QA. I guess it does handle the nulls for me.
create table testing_bug (id number, col1 varchar2(50))
insert into testing_bug values(1, 'ttt');
insert into testing_bug values(19, null);
insert into testing_bug values(12, 'nnn');
insert into testing_bug values(15, 'mmm');
insert into testing_bug values(14, 'yyy');
select count(distinct col1) from testing_bug
Of course, I looked at Metalink and all the articles there for fixing on the OCI calls and recompiling the application, but I cannot do that at the moment - has to keep the application the way it is?
Any other idea for work around in the time while I could obtain a new application copy?
Thanks a lot, mj