Hi I was just trying out the latest Build -> Beta build 181. Getting errors on Tables and Stored procedures that have Clob and Blob types defined. Do you support these types? I do not remember getting these errors in Build 134.
Could you also please provide a list of types that you are NOT going to support: ie: Clob Blob XML
Number types: NUMBER FLOAT BINARY_FLOAT BINARY_DOUBLE
Long and Raw type: LONG RAW LONG RAW
Date and Time types: DATE TIMESTAMP INTERVAL YEAR INTERVAL DAY
Row Id types: ROWID UROWID
Large object types: CLOB NCLOB BLOB BFILE
ANSI type: CHARACTER CHAR CHARACTER VARYING CHAR VARYING NATIONAL CHARACTER NATIONAL CHAR NCHAR NATIONAL CHARACTER VARYING NATIONAL CHAR VARYING NCHAR VARYING NUMERIC DECIMAL INTEGER INT SMALLINT FLOAT DOUBLE PRECISION REAL
User Defined Types REF Object Types VARRAYs Nested Tables
Any types: ANYTYPE ANYDATA ANYDATASET
XML types: XMLTYPE
URI Types HTTPURIType URIType DBURIType XDBURIType
We decided to hold off on supporting LOB's because of the complexity of implementing the LOB storage clauses. The individual LOB types will be very simple to add, it's capturing the definition of all the many, many sub-statements that we decided to wait on.
We are going to tackle this for version 2.0. Until then there is a limited work-around. You can basically develop everything else, and manually add your LOBs to the scripts that the Oracle DSP generates. It's not great, but it does get you there. Dwight
Is this information still valid? I'm currently using 126.96.36.1990 beta. It appears to import clobs and builds properly, however the DDL deployment script doesn't seem to work when attempting to create the table.
You are correct. This post is very old and v1.5.0 does support LOBs. We have been working on a serious QA cycle and have addressed many of the issues around LOBs. What issues are you having with the v188.8.131.521 Beta build?
Sorry for the long delay. Our server doesn't seem to be kicking out new post announcements to the forum leaders.