Shibboleth Developers

[giacomo tenaglia <>]

On Fri, Dec 14, 2007 at 10:35:22AM -0500, Scott Cantor wrote:
> > - some data type adjustement to the storage creation sql:
> >   datetime -> date, text -> clob (this because I dont't know what can be
> >   the maximum size of the field "value" in table "texts", otherwise I'd
> >   used varchar);
> 
> The text type is used because those operations don't impose any size limits
> (beyond what's practical to store). Usually there's a "long text" type of
> some sort that isn't exactly a blob, but I'm not familiar with Oracle.

Hi,
I'm having a problem with Oracle and ODBC.

In Oracle it's not possible to insert strings longer than 4000
charachters. For doing this it's necessary to insert the string in a
temporary clob and use it inside the INSERT.

So in order to insert in an Oracle ODBC cache the attributes received,
in my opinion there's the need for a code change, or the fork of the
plugin to another one Oracle-specific.

What do you think? I will work and see if I can provide sample working
code next week.

giacomo

-- 
giacomo tenaglia
Technical Student at CERN IT/DES-SIS
CNR Biblioteca d'Area di Bologna - http://biblio.bo.cnr.it
Phone +41 76 5003376 - 
sip: