BLOBs exported as <null> to insert scripts
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
When trying to generate "Data Scripts" (insert statements) table from an Oracle database blobs are exported as <null>. This happens when the column (attribute) which is in front of the blob-column is a Varchar2-Column and has no value i. e. it is <null>.
Example for such a table would be:
CREATE TABLE DEMOTABLE
(
ID decimal(19) PRIMARY KEY NOT NULL,
FOO nvarchar2(255),
BAR blob
);
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
Update;
Seems to happen independent of the type of the "first" column.
Tried it with an integer-column set to <null>, same behaviour.