Query oci_parse() Apache error

[John Lagoli]

I get this error, apparently because of my Query:



Apache.exe has encountered a problem and needs to close. We are sorry for
the inconvenience.





the error in on oci_parse() , but when I replace the above query with for
example "select * from clients"; I don't get the error. Though I need to
use query I put in variable $query....

All my other variables are ok, and the query works when I use it in SQL
worksheet for instance. (I use oracle 9i, php5, apche 1.3)



what can I do with that query to make it work?





$req_id = $_GET['request_id'];

print "request id : $req_id <br>";

$req_name = $_POST['request_name'];

print "request_na me -> $req_name <br>";

$req_date = $_POST['request_date'];

print "request_da te -> $req_date <br>";

$req_client_id = $_POST['request_client _name'];

print "request_client _name -> $req_client_id <br>";

$req_req_type_i d = $_POST['request_type'];

print "request_ty pe -> $req_req_type_i d <br>";

$req_brand_id = $_POST['request_brand_ name'];

if ($req_brand_id= ='Brand Name') $req_brand_id=' NULL';



print "request_brand_ name -> $req_brand_id <br>";

$req_exp_date = $_POST['request_expect ed_date'];

print "request_expect ed_date -> $req_exp_date <br>";

$req_comment = $_POST['request_commen t'];

print "request_commen t -> $req_comment <br>";



$c1=oci_connect ("john","lago") ;





$query="update requests set

request_name='$ req_name'

,request_date= to_date('$req_d ate','DD.MM.YYY Y')

,request_client _id=2

,request_reques t_type_id = $req_client_id

,request_brand_ id = $req_brand_id

,request_wished _delivery_date =
to_date('$req_e xp_date','DD.MM .YYYY')

,request_commen t ='$req_comment'

where request_id =$req_id";





$stmt=oci_parse ($c1,"select * from clients");

[Christopher.Jones@oracle.com]

Re: Query oci_parse() Apache error

"John Lagoli" <stephane.volle t@bluewin.ch> writes:
[color=blue]
> I get this error, apparently because of my Query:
>
> Apache.exe has encountered a problem and needs to close. We are sorry for
> the inconvenience.[/color]

Pull the latest php_oci8.dll from http://pecl4win.php.net/ext.php/php_oci8.dll
to make sure the problem is not a threading issue that was recently fixed.

Check and handle all function errors.

Chris

--
Christopher Jones, Oracle Corporation, Australia.
Blog: http://blogs.oracle.com/opal/