Re: Oracle, Stored Procedure Out Variable confusion
| From: | Thies C. Arntzen | Date: | Wed, 14 Feb 2001 19:52:11 +0000 |
| Subject: | Re: Oracle, Stored Procedure Out Variable confusion | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6638@lists.php.net to get a copy of this message | ||
On Wed, Feb 14, 2001 at 08:33:12PM +0100, Matthias Kopolt wrote:
> 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 ?
please create the shortest possible testcase that
demonstrates your problem and send it to the list.
tc