8.0.5.1 Bind Problem?

I have a procedure that runs the following 2 queries:

      SELECT COUNT (*)
        INTO iCount
        FROM fast.col_spec
       WHERE table_name = cTableName AND
             file_type  = cFileType;

      SELECT COUNT (*)
        INTO iCount
        FROM fast.col_spec
       WHERE table_name = 'ORDERS' AND
             file_type  = 'C2F';

The variables, cTableName and cFileType are passed into the procedure as VARCHAR2 arguments. The first query returns zero rows and the second returns the correct number of rows. I have verified the values, sizes, and capitalization of both variables within my procedure and they match the values in the hardcoded query exactly.

These queries are being run on a Sun Solaris box running Oracle 8.0.5.1. When I run the same query on a 8.0.5.0 box, both queries return the same (correct) value. I have also tested this on a 7.3.3 box and received the correct values back.

Are there any known problems in the 8.0.5.1 release that might cause this problem?

Thanks in advance,
Darren Sulfridge
des_at_dbmicro.com Received on Thu Dec 09 1999 - 11:09:16 CST