Ludovic, The long field in Oracle should be converted into blob in MySQL. Long data type is notorious (and deprecated) in Oracle, it should be replaced ASAP...
I took a quick scan on functions. The following two will need recoding. They are not plain views. F_TMC_JOBPOOLS_FOR_REPORTS f_tmc_time_modified Most of the procedures are just wrappers of insert/update/delete statements on the underlying tables. I am not sure how you handle sequences since there is no sequence in MySQL. You can identify all the primary keys and make them auto-increment, or create a few tables with auto-increment fields to serve as sequences. The procedures/wrappers will have to be changed accordingly. Steve Lihn -----Original Message----- From: Ludovic Maitre [mailto:[EMAIL PROTECTED] Sent: Monday, September 25, 2006 7:58 AM To: [email protected] Subject: Lokahi MySql progress + questions Hi all, While this is not finished, i have setup a MySql Lokahi instance: http://dev2.ubik-products.com/lokahi/ (i hope the name is already visible outside) l: lokadmin /p: adminlok I have some problems to solve with the stored procs in MySQL, which doesn't seems to like long varchar columns as arguments, but i hope to have something functional soon, that is for the end of the week. If you want to take a look, all the code is in my subversion (link in precedent mails). It is too soon to send a global patch against trunk, but i will do it as soon as i will be sure that the instance is functional. Best regards and thanks for your help, PS: i haven't used the converted sql files yet, only my Perl port (-> this can explain perhaps some of the missing functions). -- Cordialement, Ludo - http://www.ubik-products.com --- "L'amour pour principe et l'ordre pour base; le progres pour but" (A.Comte) ------------------------------------------------------------------------------ Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu - direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. ------------------------------------------------------------------------------
