Shibboleth Developers

["Scott Cantor" <>]

> 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.

I don't understand the second sentence. But the way it *should* work is by
feeding the data in a loop using a parametrized statement, but I was not
able to get that to work on Unix *at all*. I had to fall back to using
straight inserts. I was able to get the read data loops to work, so I left
those in.

(From what I could tell, the problem I had was not a driver issue but a
driver manager issue.)

> 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.

I think that the simplicity and reliability of the straight insert for
drivers that support it demands that anything for Oracle be conditional.
Probably a conditional macro set by configure.

-- Scott