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)



From fred.lindberg [...] yudoglobal.com Mon Aug 13 13: 23:29 2012
MIME-Version: 1.0
X-Spam-Status: No, score=-6.176 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, MIME_HTML_ONLY=0.723, RCVD_IN_DNSWL_HI=-5] autolearn=ham
X-Spam-Flag: NO
X-Provags-ID: V02:K0:MxY3D1ATs/GH+NUhbEI6HZ7lCYeBaL/Ssia2HUTLQ2g ZEb8M1lTW298qj0vfRZT4vD0Ha+vDS2cxkvafaE78CBMRRuRcX 2UcsoSp+WSzkvLCbqYxFzOglm/mVN6k6dNhYz32drgYtBcqUWM 7eHssbFIwCDOz4Z9jzy5Ktu1y6WFu5Ic7dvlrJbhkK6uDBHhX0 N5uXqgs6ykbHry2gqnAUY81mpndn1UWlEpcKI/jgzk3LYEZxSe L7zQWo+nq85xiuajPnqOdGanrxz38FhroxhJ4RR0Hkv78Plrwf t87u92SgMZlZDTwX5rKpkgK8y4PyjQgHEy2aYhN8DkHqqRTjEN tks2UZLh4/pjrq6YLyMHw0bc25MUoS+SfSfVNgXQ6D51BSEd0I Z1RQw37rXPDJ/emOjCRtJUAYeBvqv5TIh0=
Content-Type: text/html; charset=utf-8
Message-ID: <6856.6.b42f48 [...] ydm1.yudoglobal.com>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -6.176
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id DD2AB2406BB for <cpan-bug+sql-translator [...] hipster.bestpractical.com>; Mon, 13 Aug 2012 13:23:29 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id U1Q58X2BvkoA for <cpan-bug+sql-translator [...] hipster.bestpractical.com>; Mon, 13 Aug 2012 13:23:28 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 7E94A24047A for <bug-sql-translator [...] rt.cpan.org>; Mon, 13 Aug 2012 13:23:28 -0400 (EDT)
Received: (qmail 19973 invoked by uid 103); 13 Aug 2012 17:23:27 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 13 Aug 2012 17:23:27 -0000
Received: from moutng.kundenserver.de (HELO moutng.kundenserver.de) (212.227.17.10) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Mon, 13 Aug 2012 10:23:25 -0700
Received: from domU-12-31-38-00-B6-54.compute-1.internal (ec2-23-21-133-102.compute-1.amazonaws.com [23.21.133.102]) by mrelayeu.kundenserver.de (node=mreu1) with ESMTP (Nemesis) id 0MaoHu-1TGz4d12kc-00JoRx; Mon, 13 Aug 2012 19:23:21 +0200
Delivered-To: cpan-bug+sql-translator [...] hipster.bestpractical.com
Subject: Orable blob does not support size (ORA-00907)
Return-Path: <fred.lindberg [...] yudoglobal.com>
X-RT-Mail-Extension: sql-translator
X-Original-To: cpan-bug+sql-translator [...] hipster.bestpractical.com
X-Spam-Check-BY: 16.mx.develooper.com
Date: Mon, 13 Aug 2012 17:23:15 +0000 (UTC)
X-Spam-Level:
To: "bug-SQL-Translator [...] rt.cpan.org" <bug-sql-translator [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: Fred Lindberg <fred.lindberg [...] yudoglobal.com>
X-RT-Original-Encoding: utf-8
Content-Length: 1073
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.