Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [pl/sql] procedure making mysql script

Re: [pl/sql] procedure making mysql script

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Wed, 1 Mar 2006 09:16:13 +1100
Message-ID: <MPG.1e6f76b4e9370215989770@news.readfreenews.net>


fabi150_at_poczta.onet.pl says...

> i must create procedure. this procedure has 1 parameter and return CLOB
> with mysql script . this parameter is table name.
> for example create procedure aaa(table_name varchar2). then this
> procedure must receive name of fields,type of fields and data from this
> fields and create mysql commands with this information.(create tables
> and a lot of inserts) to CLOB and return this clob.

Try posting to comp.databases.mysql not comp.databases.oracle.server.

Cheers and good luck.

Geoff M Received on Tue Feb 28 2006 - 16:16:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US