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?

Using this code:

create table CEP
(ID varchar(100) not null, MATRICULA varchar(200)) 
engine = federated 
connection = 'mysql://CEP:a423pa@172.16.90.220:1521/CEP/USUARIOS';
[download]

I created the table normally. The problem occurs when I try to select rows from table that I create. The error:

Error Code: 1429. 
Unable to connect to foreign data source: Lost connection to MySQL ser
+ver at 'waiting for initial communic
[download]

I still fail to see where this is a Perl problem. See Re^14: DBI connect to Oracle.