ocifetch won't fetch

Yamakazi

Hey guys,

First a quick question. Is there something wrong with the PHP.net site? If you view oci_fetch you'll see that it states it might only be available in the CSV where it actually is in the PHP release since 3.0.4.

Then about the OCIFETCH function

I have the following problem. I'm fetching two values 'keyword and title'

Know i do a while ocifetch problem is php won't fetch a thing if one of the values is a null value. Wich off course is the case. Title is always inserted but keyword isn't. Is there a way to by pass this and just fetch the title and leave keyword empty?

Thx in advance

bastien

set the default value to an empty string instead of a null in oracle...then it always returns something

we have a similiar problem with mysql and myodbc drivers (ASP) and that is our solution

Yamakazi

I solved halve of my problem by using ocifetchinto and setting the parameter OCI_RETURN_NULLS. Know still an error is fired when i try to fetch without there being a single record in the resultset.

if i do this

ocifetchinto($stmt, $result, OCI_ASSOC+OCI_RETURN_NULLS)or die("Shot during fetch :)");

And the recordset is empty i get Shot during fetch.

Is there away to by pass this? . . .
that is easier then this construction:

if(oci_num_rows($stmt)>0){
  ocifetchinto($stmt, $result, OCI_ASSOC+OCI_RETURN_NULLS)or die("Shot during fetch :)");
}

TIA