Re: No resultset with ocibindbyname
| From: | Christopher Jones | Date: | Wed, 27 Feb 2008 02:03:27 +0000 |
| Subject: | Re: No resultset with ocibindbyname | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44668@lists.php.net to get a copy of this message | ||
Manuel Schölling wrote:
Hi Christopher, thanks for caring about my problem. ;)Do other queries with binds work? Is PHP using the correct NLS language configuration? Chris -- Christopher Jones, Oracle Email: christopher.jones@oracle.com Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jadI 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.