#1052 BLOBs exported as <null> to insert scripts

3.4.0
open
Rob Manning
5
2012-12-29
2012-10-11
Anonymous
No

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
);

Discussion


  • Anonymous
    2012-10-11

    Update;

    Seems to happen independent of the type of the "first" column.
    Tried it with an integer-column set to <null>, same behaviour.