Re: procedure making mysql script

From: Gerry Atric <f_at_t.chance.com>
Date: Wed, 01 Mar 2006 18:57:34 GMT
Message-ID: <y8mNf.7998$Cp4.143@edtnps90>

zks wrote:

> i have table in oracle. i put name of this table as parameter in
> procedure(pl/sql procedure). then thiis procedure must receive name of
> fields,type of fields ,data from rows (from table who i put as
> parameter) and from this information i must create mysql script and
> return it as CLOB. ufff :).

Hehe... there is no magic built-in function that will do this. You have to use the data dictionaries to retrieve schema object details... then develop code to recreate the mysql-compatible DDL... then more code to dump the data into mysql-compatible DML. I've been there done that, and I'd be happy to license my code to you for an appropriate fee. Received on Wed Mar 01 2006 - 12:57:34 CST