Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^13: DBI connect to Oracle

by Anonymous Monk
on Feb 24, 2015 at 14:17 UTC ( [id://1117656]=note: print w/replies, xml ) Need Help??


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 = '????';

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.

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

        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?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1117656]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (3)
As of 2024-04-19 05:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found