Bug #78939 for SQL-Translator: Orable blob does not support size (ORA-00907)

Subject:	Orable blob does not support size (ORA-00907)
Date:	Mon, 13 Aug 2012 17:23:15 +0000 (UTC)
To:	"bug-SQL-Translator [...] rt.cpan.org" <bug-sql-translator [...] rt.cpan.org>
From:	Fred Lindberg <fred.lindberg [...] yudoglobal.com>

SQL-Translator-0.11012
Producer::Oracle.pm
3.2.0-27-generic-pae #43-Ubuntu
This is perl 5, version 14, subversion 2 (v5.14.2)

Hi, I am using your very helpful module to parse MySQL-workbench output DDL and trying to convert to Oracle DDL. The for MEDIUMBLOB and LONGBLOB in MySQL, the Oracle producer output fields with size specified, leading to an oracle "missing right parentesis" error:

commContent MEDIUMBLOB NULL ,
=>
commContent blob(16777215),

attContent LONGBLOB NULL ,
=>
attContent blob(4294967295),

Fix:
There is already code to undef size for date and clob. Add blob (line 609):

    #
    # Fixes ORA-00907: missing right parenthesis
    #
    if ( $data_type =~ /(date|clob|blob)/i ) {
        undef @size;
    }

This produces instead:

commContent blob,
attContent blob,

Thanks!
Fred Lindberg