php+oracle8+lob

i know how to save a file in oracle8 lob field. but how to do the reverse? To Read from lob and save it to a file.

thanks.

Suppose you do a

SELECT NAME,DATA FROM STUFF

where data is a lob.

$cur = ociparse($conn,"SELECT NAME,DATA FROM STUFF");
ociexecute($cur);
ocifetchinto($cur,$data,OCI_RETURN_LOBS);

that should do it. alternatively you could skip the OCI_RETURN_LOBS part and call the load method of the lob.

$cur = ociparse($conn,"SELECT NAME,DATA FROM STUFF");
ociexecute($cur);
ocifetchinto($cur,$data);

// Data is an arrat with it's second param
// being a LOB
$data[2]->load();

i think the method will work if the lob contains small data. but the lob may contain any large data up to 4G,can i load it directly to memory?

thanks

I don't think there is another way, either clob->load() or ocifetchinto($stmt,$data,OCI_RETURN_LOBS).

yavo