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_name -> $req_name <br>";

$req_date = $_POST['request_date'];

print "request_date -> $req_date <br>";

$req_client_id = $_POST['request_client_name'];

print "request_client_name -> $req_client_id <br>";

$req_req_type_id = $_POST['request_type'];

print "request_type -> $req_req_type_id <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_expected_date'];

print "request_expected_date -> $req_exp_date <br>";

$req_comment = $_POST['request_comment'];

print "request_comment -> $req_comment <br>";

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

$query="update requests set

request_name='$req_name'

,request_date= to_date('$req_date','DD.MM.YYYY')

,request_client_id=2

,request_request_type_id = $req_client_id

,request_brand_id = $req_brand_id

,request_wished_delivery_date =
to_date('$req_exp_date','DD.MM.YYYY')

,request_comment ='$req_comment'

where request_id =$req_id";

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

[Christop...@oracle.com]

"John Lagoli" <stephan...@bluewin.ch> writes:

> 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.

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/