So, what can I do to retrieve a blob in oracle?
Any one has a code for this.
----- Original Message -----
From: "Mark" <mark_weinstock@xxxxxxxxx>
To: "Naif Al-Otaibi" <naif@xxxxxxxxxxxx>
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 <naif@xxxxxxxxxxxx> 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
> mark_weinstock@xxxxxxxxx
> ***************************************
> 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
|
