in reply to Re^12: DBI connect to Oracle
in thread DBI connect to Oracle

Great. Got my mistake: I was creating "archive data source". The correct is create a "user" or "system data source".

Now, I have to create a table on mySQL, and I think that I have to use a Federated table, but I donīt know how. Maybe something like: 

create table CEP3 
(ID varchar(100) not null, MATRICULA varchar(200)) 
engine = federated 
connection = '????';

[download]

Replies are listed 'Best First'.
Re^14: DBI connect to Oracle
by Corion (Patriarch) on Feb 24, 2015 at 15:17 UTC

    I think this is more an Oracle problem than a Perl problem.

[reply]
      Maybe. But do you know how to create the script to MySQL?
[reply]

        I guess that you can find the answer in the MySQL documentation. Or maybe you can pay an Oracle consultant to answer your question.

        What error message did you get, or how else did MySQL fail to do what you want?

[reply]

In Section Seekers of Perl Wisdom