Edit report at https://bugs.php.net/bug.php?id=54664&edit=1
ID: 54664
Updated by: s...@php.net
Reported by: rattonwing at yahoo dot com
Summary: Warning oci_fetch_object() -->Trying to get property
of non-object
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: OCI8 related
Operating System: Windows 7
PHP Version: 5.3.6
Block user comment: N
Private report: N
Previous Comments:
------------------------------------------------------------------------
[2011-11-07 22:35:38] s...@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
Please give a standalone PHP script and a SQL creation script that reproduces
the
problem.
Oracle objects created with case-insensitive names in the DB will be returned
to
PHP OCI8 with uppercase names. See the fetch_object*.phpt examples in
http://svn.php.net/viewvc/php/php-src/trunk/ext/oci8/tests/
------------------------------------------------------------------------
[2011-05-05 05:57:16] rattonwing at yahoo dot com
Description:
------------
---
>From manual page: http://www.php.net/function.oci-fetch-object#Description
---
Env:Joomla
[begin]
Warning: oci_fetch_object() [function.oci-fetch-object]: ORA-24374: define not
done before fetch or execute and fetch in O.php on line 587
Notice: Trying to get property of non-object in X.php on line 78
[end]
Test script:
---------------
if (!($cur = $this->query()))
return null;
if ($object =oci_fetch_object($cur))
$ret = $object;
ocifreestatement($cur);
...
$this->_oradb->setQuery($query);
$result = $this->_oradb->loadObject();
$this->DesireProp = $result->FromOra;
Expected result:
----------------
$this->DesireProp is not null (a year number)
Actual result:
--------------
Notice: Trying to get property of non-object
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=54664&edit=1
