RE: [phplib] Long session strings and Oracle From: Francesco.Marsan <email protected>
Date: 06/26/00

Apparently ocibindbyname() shoud work for CLOBs as well. Can you try it?

-----Original Message-----
From: Björn Schotte [mailto:bjoern <email protected>]
Sent: Monday, June 26, 2000 12:54 PM
To: Francesco.Marsan <email protected>
Cc: kpmd <email protected>; phplib <email protected>
Subject: Re: [phplib] Long session strings and Oracle

Hi,

* Francesco.Marsan <email protected> wrote:
> I worked around this problem using CT_Split_Sql, which works fine for me.

Furthermore, what about CLOBs which are used by your
application and you want to INSERT/UPDATE something
in it?

E.g.

  $db->query("insert into template(tid,htmlcode) ".
             "values(1,'$hugestring')");

I get problems when $hugestring has more than about
~ 3000 characters. :-( Any solutions? I don't want
to use oracle specific code inside my application
because it should run under MySQL as well.

(Using Oracle 8.1.6 with db_oci8.inc)

-- 
<?php class new_media_development {
        var $url="http://www.rent-a-phpwizard.de/";
        var $fon="0931/7843792"; var $fax="0931/7843795";
} /* Björn Schotte, "Mr. PHP" */ ?>

--------------------------------------------------------------------- To unsubscribe, e-mail: phplib-unsubscribe <email protected> For additional commands, e-mail: phplib-help <email protected>