SQLWays is capable of converting Oracle PL/SQL to Java classes.

Challenges

SQLWays has build-in functionality of migrating Oracle packages, triggers, procedures and functions to Java classes with methods. Database connection is not compulsory for migration with SQLWays. A separate file is created for each PL/SQL element, which simplifies conversion results monitoring and migration reports preparation. We are providing 90+% automated conversion rate with regular SQLWays version. Availability of qualified and skillful support helps achieving up to 100% automation rate for the entire migration process with custom versions of the tool.

Why SQLWays

SQLWays and our support ensure low cost and nearly 100% automation of Oracle PL/SQL to Java conversion.

Conversion Features

• Variable Declarations and Assignments
  SQLWays takes into account variables with predefined data types, such as NUMBER, VARCHAR, as well as the types with %TYPE and %ROWTYPE. Our tool recognizes and defines proper types by using database tables or DDL.
• SQL Statements
  SQLWays migrates SQL Statements into Prepared Statements in Java. All variables in SELECT, UPDATE, DELETE or INSERT statements are used in setDatype. Also, our tool correctly sets and extracts data types regarding the data types in corresponding tables.
• PL/SQL Built-in Functions
  Almost all functions in Oracle have equivalents in Java, but some individual and specific situations occur. Ispirer's individually-tailored approach allows us to create and implement these specific solutions into SQLWays within short period of time.
• Cursors
  SQLWays has capabilities of converting cursors in SELECT statements. They are stored in ResultSet and extracted into variables or Class that was created for the cursors.
• Result Sets
  Oracle result sets are presented by class ResultSet. This class is used for storing results of the SELECT statements. Values of all columns are extracted into corresponding variables.
• Exceptions
  Oracle exceptions are converted to try-catch-finally block in Java. All SQLCodes are processed in catch block using IF operator
• Collections and Records
  Java's HashTable and Map are equivalents for the Collections and Records in Oracle. In some specific cases, SQLWays generates inner class with methods which simulate original methods of the collections.

If you are interested in these services, please This e-mail address is being protected from spambots. You need JavaScript enabled to view it for more information.