Re: How could I read a CLOB in webpage?
| From: | chang | Date: | Fri, 01 Sep 2000 04:48:12 +0000 |
| Subject: | Re: How could I read a CLOB in webpage? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2546@lists.php.net to get a copy of this message | ||
I have the error message like this:
Fatal error: Call to a member function on a non-object
what's the problem?
$stmt = ociparse($conn,"select CONT_CONTENT from content where
CONT_DRAFT_ID = :ID");
ocibindbyname($stmt,":ID",&$id,-1);
if (!ociexecute($stmt)) { print "execution failed"; exit(); }
ocifetchinto($stmt, &$arr,OCI_ASSOC);
echo $arr["CLOB"]->load();
--
???
????????
TEL:2570-1213#163 FAX:2577-4708
??????3?30?11?
<thies@digicol.de> ????? news:20000831172019.B4441@godzilla.digicol.old...
> On Thu, Aug 31, 2000 at 01:37:18PM +0800, chang wrote:
> > I follow the example in www.php.net
> >
> > $sql = OCIParse($conn,"select * from table_with_lob_field");
> > OCIExecute($sql);
> > while ( OCIFetchInto($sql, $row, OCI_ASSOC) )
> >
> > $lob_data = $row[lob_field_name]->load();
> $lob_data = $row["LOB_FIELD_NAME"]->load();
>
> oracle returns rows always in UPPERCASE.
>
> > echo $lob_data;
> > }
> >
> > but I still couldn't show the data in my webpage.
> > Could anyone help me? thanks!
> >
> > Michael Chang
> >
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
> --
>
> Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
> Digital Collections Phone +49 40 235350 Fax +49 40 23535180
> Hammerbrookstr. 93 20097 Hamburg / Germany
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>