Re: DBD::Oracle and m2o.pl

From: Michael A Chase tech (mchase_at_ix.netcom.com)
Date: 12/30/04

  • Next message: Ron Reidy: "RE: DBD::Oracle and m2o.pl"
    Date: Wed, 29 Dec 2004 18:04:56 -0800
    To: "Maldonado, Daniel CW2 CTARNG" <daniel.maldonado@CT.NGB.ARMY.MIL>
    
    

    On 12/29/2004 10:56 AM, Maldonado, Daniel CW2 CTARNG said:

    > Hi there again, this may not be the best forum to ask this question but I
    > don't think there is a DBD::Oracle list available.

    This is the right place. The DBI list is a good first stop for all DBI
    and DBD user issues.

    > Does anyone have a script that can convert a mysqldump file to a sqlplus
    > script?

    That's not really a DBI issue, if you know the format of the file you
    can convert it to anything you want. You could also write it directly
    to Oracle using DBI and DBD::Oracle.

    > Oreilly lists it at:
    > http://www.oreillynet.com/oracle/os_dir/commandline.csp

    http://www.google.com/search?q=m2o.pl

    I think I found the source in an email at
    http://bincang.net/forum/archive/index.php/t-55513.html

    It looks like development ended with version 1.91 in 2001, but it should
    give you a start. If you have to re-write it much, you might want to
    generate sqlloader control and data files instead of SQL*Plus.

    -- 
    Mac :})
    ** I usually forward private questions to the appropriate mail list. **
    Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
    Give a hobbit a fish and he eats fish for a day.
    Give a hobbit a ring and he eats fish for an age.
    

  • Next message: Ron Reidy: "RE: DBD::Oracle and m2o.pl"

    Relevant Pages

    • Re: how to connect postgresql database with perl
      ... > How to connect postgresql database with perl? ... and execute in the DBI manual. ... Give a hobbit a ring and he eats fish for an age. ...
      (perl.dbi.users)
    • Re: Sending Mail
      ... > sub open_dbi ... to explicitly check for errors at nearly every DBI method call. ... Give a hobbit a ring and he eats fish for an age. ...
      (perl.dbi.users)
    • Re: HELP PLEASE! Problems using returning a cursor to DBI & DBD::Oracle using Stored Procedures
      ... > write PL/SQL for Perl DBI. ... > which loop through the results set fetching the data into output ... Give a hobbit a ring and he eats fish for an age. ...
      (perl.dbi.users)
    • Re: How can I...
      ... My first thought was to SELECT COUNTFROM TABLE, but DBI catches the ORA-942 error and I don't know how to catch that. ... perldoc works for most other Perl modules and you can see everything about the modules in CPAN. ... Give a hobbit a ring and he eats fish for an age. ...
      (perl.dbi.users)
    • Re: Describe
      ... more portable method is to use the DBI methods.... Give a hobbit a ring and he eats fish for an age. ...
      (perl.dbi.users)