Re: No resultset with ocibindbyname
| From: | Manuel Schölling | Date: | Mon, 25 Feb 2008 23:03:41 +0000 |
| Subject: | Re: No resultset with ocibindbyname | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44649@lists.php.net to get a copy of this message | ||
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.
Cheers,
Manuel