Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    14

    Question Unanswered: Migration from Oracle to MySQL

    Hi Friends,

    I'm working on a migration project from Oracle to MySQL. We have lot of procedures in Oracle that needs to be converted to MySQL. I would like to know the equivalent of Oracle's "EXCEPTION when {exception} then ....." in MySQL.

    For example, I would like to know whether the SQL Statement i'm firing within the procedure returns row or not - if no rows is returned then do logic a else do logic b

    Thanks in advance

  2. #2
    Join Date
    Mar 2004
    Posts
    33
    Hi,

    Check SwisSQL.
    http://www.swissql.com

    Regards,

  3. #3
    Join Date
    Oct 2004
    Posts
    14

    Cool

    Thanks expert_db.

    I used the HANDLERs for the above requirement. It works perfectly fine.

    DECLARE EXIT HANDLER FOR NOT FOUND
    begin
    // Your logic for not found to be inserted here
    end;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •