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

People
Owner: Nobody in particular
Requestors: fred.lindberg [...] yudoglobal.com
Cc:
AdminCc:

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 [...] 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


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

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.