Page 1 of 1
Long datatype in OracleSessionStateProvider sql table script
Posted: Wed 14 Jan 2009 15:34
by CTartaglia
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
Posted: Wed 14 Jan 2009 17:41
by Shalex
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.
Posted: Fri 16 Jan 2009 12:16
by Shalex
The issue is fixed. Look forward to the next build of dotConnect for Oracle. I will notify you when it is released.
Posted: Fri 20 Feb 2009 14:34
by Shalex
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