Long datatype in OracleSessionStateProvider sql table script

CTartaglia · Post by **CTartaglia** » Wed 14 Jan 2009 15:34

In the database table script that is provided with the OracleSessionStateProvider, one of the columns has a LONG datatype. Is there any way to change this to a LOB type (BLOB or CLOB) or similiar type? The DBAs at my organization will not run the script with the LONG type since it is basically depricated by Oracle.

Thanks in advance.
-Chris

Shalex · Post by **Shalex** » Wed 14 Jan 2009 17:41

Hello Chris,

We have checked our InstallWebTables script (Program Files\Devart\dotConnect\Oracle\InstallWebTables.sql). There are two columns with the LONG type: the sessionitems column from the aspnet_sessions table and the details column from the aspnet_webevent_events table.

We will try to modify our provider to make it possible to work with these two columns in 2 cases:
1) if they are of the LONG type;
2) and if they are of LOB type (BLOB or CLOB) - you will need just change the type before executing the InstallWebTables script.

You will be notified about the results as soon as possible.

Shalex · Post by **Shalex** » Fri 16 Jan 2009 12:16

The issue is fixed. Look forward to the next build of dotConnect for Oracle. I will notify you when it is released.

Shalex · Post by **Shalex** » Fri 20 Feb 2009 14:34

The new build (5.00.22) of dotConnect for Oracle is available now.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=14185