[PHP-DB] Error in retrieving a blob from oracle DB.

2002-11-28 Thread Naif Al-Otaibi 

Hi all,

I use the following:
1) Win XP.
2) Oracle personal eddition 8.1.6.0.0.
3) IIS.
4) php-4.2.3-Win32 runs in cgi mode.

When I retrieve a blob from my DB, I got the following error:

Fatal error: Call to undefined function: load() in 
c:\inetpub\wwwroot\php1\ora52.php on line 6

---
This is my code:

?php
$conn = OCILogon(system,manager,naif.localhost);
$stmt = OCIParse($conn,select binary_junk from images where 
img_id=7);
OCIExecute($stmt);
OCIFetchInto($stmt, $lob);
$content=load($lob);
OCIFreeStatement($stmt);
OCILogoff($conn);
header(Content-type: image/gif\n\n);
echo $content;
?


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Error in retrieving a blob from oracle DB.

2002-11-28 Thread Naif M. Al-Otaibi 
So, what can I do to retrieve a blob in oracle?
Any one has a code for this.

- Original Message -
From: Mark [EMAIL PROTECTED]
To: Naif Al-Otaibi [EMAIL PROTECTED]
Sent: Thursday, November 28, 2002 4:37 PM
Subject: Re: [PHP-DB] Error in retrieving a blob from oracle DB.


 Load() does not seem to be a valid function in PHP.


 --- Naif Al-Otaibi [EMAIL PROTECTED] wrote:
 
  Hi all,
 
  I use the following:
  1) Win XP.
  2) Oracle personal eddition 8.1.6.0.0.
  3) IIS.
  4) php-4.2.3-Win32 runs in cgi mode.
 
  When I retrieve a blob from my DB, I got the following error:
 
  Fatal error: Call to undefined function: load() in
  c:\inetpub\wwwroot\php1\ora52.php on line 6
 
  ---
  This is my code:
 
  ?php
  $conn = OCILogon(system,manager,naif.localhost);
  $stmt = OCIParse($conn,select binary_junk from images where
  img_id=7);
  OCIExecute($stmt);
  OCIFetchInto($stmt, $lob);
  $content=load($lob);
  OCIFreeStatement($stmt);
  OCILogoff($conn);
  header(Content-type: image/gif\n\n);
  echo $content;
  ?
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 


 =
 Mark Weinstock
 [EMAIL PROTECTED]
 ***
 You can't demand something as a right unless you are willing to fight to
death to defend everyone else's right to the same thing.
 -Stolen from the now-defunct Randy's Random mailing list.
 ***

 __
 Do you Yahoo!?
 Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
 http://mailplus.yahoo.com



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php