Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 78939
Status: new
Priority: 0/
Queue: SQL-Translator

Owner: Nobody in particular
Requestors: fred.lindberg [...]

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

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

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,

Fred Lindberg

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to