THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

Oracle Pro*C to MySQL C API Conversion

Ispirer MnMTK provides Oracle Pro*C to MySQL C API conversion.

Conversion features

Ispirer MnMTK tool automatically detects EXEC SQL statements and host variables and converts them to MySQL C API and pastes additional code.

  • EXEC SQL DML and DDL statements are converted to query string;
  • MySQL API function and variable are added to Data Base access and fetch data;
  • MySQL header file is added.

Oracle Pro*C example (file: simple.pc):

  1. int Customer::getNumPrefix(sql_context sqlContext)
  2. {
  3. EXEC SQL CONTEXT USE :sqlContext;
  4.  
  5. EXEC SQL SELECT COUNT(1) , MAX(CUSTOMER_ID)
  6. INTO :prefixMatchCount, :matchingPrefix
  7. FROM CUSTOMER;
  8. return prefixMatchCount;
  9. }

After the conversion simple.pc file is converted to simple.cpp:

  1. #include <mysql.h>
  2. #include <string.h>
  3. #ifndef MAXSQL
  4. #define MAXSQL 4000
  5. #endif
  6. int Customer::getNumPrefix(MYSQL *sqlContext)
  7. {
  8. char strQuery[MAXSQL] = "SELECT COUNT(1) , MAX(CUSTOMER_ID) "\
  9. " FROM CUSTOMER";
  10. mysql_real_query(sqlContext,strQuery,strlen(strQuery));
  11. MYSQL_RES *result;
  12. MYSQL_ROW *record;
  13. result = mysql_store_result(sqlContext);
  14. record = mysql_fetch_row(result);
  15. prefixMatchCount = record[0];
  16. matchingPrefix = record[1];
  17. return prefixMatchCount;
  18. }

Also Ispirer MnMTK tool provides Oracle to MySQL database migration.

Please complete the questionnaire to initiate collaboration discussions for your project or get some rough estimation:


If you are interested in these services, please contact us for more information.

 
Testimonials
November 25, 2013Ciber, Sweden
Oracle to Microsoft SQL Server Migration
(including PowerBuilder migration)

"Ciber develops system for parking permits to the major cities in Sweden.
In 2012, when the second largest city in...

...

August 21, 2014TouchStone Systems, Inc., United States
Sybase ASA to Microsoft SQL Server Migration
(including embedded SQL migration in PowerBuilder)

"To whom it may concern,

Being a leading provider in reverse logistics solutions, we continue to...

...

Case Studies
August 24, 2014PostgreSQL to Oracle Migration, United States (including embedded SQL migration in Java)

The client was a U.S.-based, non-profit organization working within the education sector, striving to ensure equal rights of students in low-income groups across the United States. This was...

...

September 11, 2014Informix to SQL Server Migration, United States (including embedded SQL migration in PowerBuilder, VB to C#, ASP to ASP.NET)

A U.S.-based renowned lessor of trailers requested the services of Ispirer to perform a major migration.

...

Feedback

I’ve just tested your tool and I’ve really appreciated the high quality of the conversion, the tool is easy and pleasant to use.

Read more
Industry Events