oci is not supported (compiled with --with-oci8=no).
$query = "SELECT * FROM \"testing_blob\" WHERE \"file_id\" = '1";
Missing ' I think.
You should get:
Fatal error: Call to undefined function ociparse() in ...
Look in the hs_err_pid1704.log it should show where the error is located.
Thanks for your reply.
i need to use oci8 to connect to oracle.
since oci8 is not supported, is that mean that i can't use oci8 in jboss ?
oci8 is not supported in jbossweb you have to use ODBC instead (Oracle supports ODBC).
ODBC allows you to use any database.
If you want to use oci8 with jbossweb you could try building the package.
The building tools are in svn at http://svn.jboss.org/repos/jbossreflex/trunk/php
just replace in buildphp.sh:
If oci8 is install in its default location.