Re: 8.0.5.1 Bind Problem?

A copy of this was sent to des_at_dbmicro.com (Darren Sulfridge) (if that email address didn't require changing) On Thu, 9 Dec 1999 11:09:16 -0600, you wrote:

>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.
>

make sure the columns table_name and file_type are not CHAR in the 8.0.5.1 database.

>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

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 09 1999 - 12:12:42 CST