ID: 32722
Updated by: [EMAIL PROTECTED]
Reported By: fsurleau at skyservices dot net
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: linux
PHP Version: 4.3.11
New Comment:
Yes, amazing but true: Even Oracle has bugs in it!
Previous Comments:
------------------------------------------------------------------------
[2005-04-20 19:39:52] fsurleau at skyservices dot net
A small bug in collection.php :
if( @OCINewCollection( $cnx, "MY_COLLECTION_TYPE" ) )
of course should be :
if( ! @OCINewCollection( $cnx, "MY_COLLECTION_TYPE" ) )
An other thing, this bug occurs with Oracle 9.2 Oci8 client.
With Oracle10g Oci8 or Oracle10g instant client, the problem doesn't
occur.
But... I can't use the oracle10g client because of bug #32741.
Maybe this indicates that the bug isn't in PHP's OCI8 API ?
Regards,
Fred.
------------------------------------------------------------------------
[2005-04-19 14:45:42] fsurleau at skyservices dot net
The xxx in the query is juste an example of query with a quote to
generate the ORA-01756 error.
You can run the scripts with your own Oracle base replacing $user,
$pass, $db_name with your own ids.
------------------------------------------------------------------------
[2005-04-19 14:27:52] [EMAIL PROTECTED]
Could you please prepare a short reproduce script, which I can
copy&paste to reproduce the problem? Those parts of your code with
'xxx' and undeclared variables do not help much. Thanks.
------------------------------------------------------------------------
[2005-04-18 13:19:31] fsurleau at skyservices dot net
Sorry, I can't use PHP5.
------------------------------------------------------------------------
[2005-04-18 13:18:03] fsurleau at skyservices dot net
Reproduce bad_query.php code is :
$cnx = ociPLogon( $user, $pass, $db_name );
if( ! @ociparse( $cnx, "select sysdate from dual where
'xxxxxx'='xxx\\'xxx'" ) )
{
$oerr = OCIError( $cnx );
echo "Error in statement : ".$oerr['message'] . "<br><br>";
}
echo "PID=" . getmypid();
The collection.php code is :
$cnx = ociPLogon( $user, $pass, $db_name );
if( @OCINewCollection( $cnx, "MY_COLLECTION_TYPE" ) )
{
$oerr = OCIError( $cnx );
echo "Error for collection : " . $oerr['message'] . "<br><br>";
}
else
{
echo "OK for collection .<br><br>";
}
echo "PID=" . getmypid();
It was cut at first post...
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/32722
--
Edit this bug report at http://bugs.php.net/?id=32722&edit=1
