Posts:
8
Registered:
7/30/09
|
|
|
|
Beta build 181 and Clob and Blob Support
Posted:
Oct 5, 2009 8:15 AM
|
|
|
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
etc.
Thanks,
Matt
|
|
|
Posts:
80
Registered:
5/13/06
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Oct 6, 2009 9:44 AM
in response to: Matt M
|
|
|
Great question, Matt. Let me see if I can pull a list together and shoot it back to you.
-- Daniel
|
|
|
Posts:
80
Registered:
5/13/06
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Oct 6, 2009 12:11 PM
in response to: Matt M
|
|
|
Here's the list. Not supported types are in red
Character types:
CHAR
VARCHAR2
NCHAR
NVARCHAR2
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
Spatial types:
Media types:
|
|
|
Posts:
8
Registered:
7/30/09
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Oct 6, 2009 5:03 PM
in response to: dnorwood
|
|
|
Hi,
Thanks for the Answer.
Just wondering though, why the following types:
CLOB
NCLOB
BLOB
BFILE
will not be supported? Especially, the CLOB and BLOB? Also XMLTYPE
Thanks Again
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Oct 6, 2009 5:21 PM
in response to: Matt M
|
|
|
Matt,
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.
Dwight
|
Dwight
|
|
Posts:
8
Registered:
7/30/09
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Oct 6, 2009 5:42 PM
in response to: Dwight
|
|
|
Hi Dwight,
Thanks for the speedy response.
Yes, the defintions for the Lobs can get complex.
Is there some workaround for this?
If not, puts me in a bit of a pickle though, a number of the tables in our db have clobs and blobs. Guess will then have to wait for V2.
Thanks Again,
Matt
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Oct 7, 2009 10:51 AM
in response to: Matt M
|
|
|
Matt,
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
|
Dwight
|
|
Posts:
15
Registered:
8/9/11
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Sep 6, 2011 11:11 AM
in response to: dnorwood
|
|
|
Is this information still valid? I'm currently using 1.5.0.500 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.
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Beta build 181 and Clob and Blob Support
Posted:
Sep 22, 2011 4:28 PM
in response to: timmy
|
|
|
Timmy,
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 v1.5.0.501 Beta build?
Sorry for the long delay. Our server doesn't seem to be kicking out new post announcements to the forum leaders.
|
Dwight
|
|
|
Legend
|
|
MVP: 2501
+
pts
|
|
Guru: 2001
- 2500
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
