Manuel Schölling wrote:
Hi Christopher,
thanks for caring about my problem. ;)
I couldn't reproduce your problem. What does your table look like?
What version of PHP & OCI8? What version of Oracle?
I using PHP 5.2.5 on a Linux 2.6.9 machine. The version of OCI8 is 1.2.4
(Revision 1.269.2.16.2.38, Oracle Instant Client Version 10.2).
The output of "select * from v$version" is:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Developmen
NLSRTL Version 3.4.1.0.0 - Production
And here is the output of "desc projekte_generisch":
Name Null? Type
PID NOT NULL CHAR(8)
ANFANG NOT NULL VARCHAR2(8)
ENDE VARCHAR2(8)
LAENGE NOT NULL NUMBER
And of course the data record I am searching for.
select * FROM projekte_generisch where pid='u0test'
PID ANFANG ENDE LAENGE
u0test utest 8
Hope this helps diagnosting the error.
Do other queries with binds work? Is PHP using the correct
NLS language configuration?
Chris
--
Christopher Jones, Oracle
Email: christopher.jones@xxxxxxxxxx Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
