Oracle, Stored Procedure Out Variable confusion
| From: | Matthias Kopolt | Date: | Wed, 14 Feb 2001 19:33:12 +0000 |
| Subject: | Oracle, Stored Procedure Out Variable confusion | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6637@lists.php.net to get a copy of this message | ||
confusion:
Using PHP 4.0.3pl1 with oci8 libraries and Oracle 8.1.6 there seems to be
problem when retrieving OUT-Variables from stored procedure, bind to a
variable.
for example i got an error retrun value (parsed to SQL as :1 and bind to
$error with a buffer of 4) it could !! happen that $error looks like 0
[zero] but is not a [zero] but something else sometime $error == 0 is true,
sometimes it false ...
WOrkaraund: using it as a string helped "$error" == "0" is always true when
$error looks like a zero. there is no sign of some extra spaces or invisible
chars. strlen is always 1 and print always prints 0. But sometimes zero
isn#t less enough ... ;-)
Did someone else face this problem or do you know if this is fixed in later
releases or if this a special NET8 remote DB on linux and client on solaris
problem ?
mk