Page 1 of 1

Can't load Blob with oci8

Posted: Fri Nov 13, 2009 1:46 pm
by estero2002
Hi, I'm trying to load a blob from an oracle db. The purpose is for downloading a file from the db. I've searched on the web and it seems to be always the same procedure:

Code: Select all

 
//$stmt is a valid descriptor for the executed query 'select blobcol from blobtable'
$result = oci_fetch_assoc($stmt);
$outVar = $result['blobcol']->load();
//At this point the variable $outVar turns to be null (tested with var_dump and by sending the headers and the var and downloading the file)
 
Any ideas?

Thank you in advance

Steve

Re: Can't load Blob with oci8

Posted: Fri Nov 13, 2009 6:32 pm
by McInfo
PHP Manual: [url=http://www.php.net/manual/en/function.oci-fetch-assoc.php]oci_fetch_assoc()[/url] wrote:Note: Oracle returns all field names in uppercase and associative indices in the result array will be uppercased too.
Edit: This post was recovered from search engine cache.

Re: Can't load Blob with oci8

Posted: Mon Nov 16, 2009 7:08 am
by estero2002
Yes, I've already tried that. I just forgot to modify it when I copied the code

Any other suggestions? I'm really stucked with this


thank you

Re: Can't load Blob with oci8

Posted: Mon Nov 16, 2009 1:30 pm
by McInfo
Is the query in upper-case too?

It might help if you post more of the script.

Edit: This post was recovered from search engine cache.