rbragg Posted March 7, 2008 Share Posted March 7, 2008 Good afternoon! I am trying to retrieve a blob from my db like this: <?php $queryGetBlob = "SELECT contract_file FROM schema.TABLE WHERE contract_num = 23"; $getBlobResult = ociparse($connect, $queryGetBlob); ociexecute($getBlobResult); while($arrayBlob = ocifetch($getBlobResult)) { echo $arrayBlob['CONTRACT_FILE']->load(); } ocifreestatement($getBlobResult); ?> I get these errors: PHP Warning: Cannot use a scalar value as an array and PHP Fatal error: Call to a member function on a non-object I realize that the first error is stating that $arrayBlob is not an array but I'm not sure why it isn't. This is my first time trying to fetch a blob. Can someone lend a hand? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/94943-selecting-a-blob/ Share on other sites More sharing options...
gluck Posted April 9, 2008 Share Posted April 9, 2008 echo $arrayBlob['CONTRACT_FILE']; This should display your results Quote Link to comment https://forums.phpfreaks.com/topic/94943-selecting-a-blob/#findComment-513395 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.