Shared session with Oracle database

[Cantor, Scott]

On 10/14/15, 6:52 AM, "users on behalf of Knut Erik Helgesen" <users-bounces at shibboleth.net on behalf of knut.helgesen at bouvet.no> wrote:



>The guide includes SQL for MySQL, however, we are only able to use Oracle 11G databases. The table "texts" contains a column of type text, and this data type does not exist in Oracle.

Some equivalent type must exist. The ODBC type is SQL_LONGVARCHAR.

> Suggested replacement is varchar2 or clob, and I assume clob will not work
> here?

The code is not written in terms of any database's types. The information I have is what's in the wiki, and as you can see nobody using Oracle has provided any documentation for it.

>Will the session sharing store so much data that the 4k limit on Oracle varchar2 fields will become a problem?

Yes. It won't work.

-- Scott