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 PL/SQL to Vertica


Conversion Features

Ispirer MnMTK has a built-in capability of migrating Oracle packages, procedures and functions to Java classes with generic rules to create scalar functions for Vertica. The tool will create a few separate files for each PL/SQL element.

From one PL/SQL function or procedure two files are created:

  • File with function class that carries out the processing you want your UDF to perform.
  • File with factory class that provides metadata about the function class, and creates an instance of it to handle function calls.

Oracle procedure migration

Source Oracle procedure:

  2. CREATE OR REPLACE PROCEDURE types_migration
  3. AS
  4. g NUMBER(10,0);
  5. p NUMBER(4,0);
  6. j NUMBER(11,0);
  7. i NUMBER;
  8. BEGIN
  9. j:=10;
  10. END;

Java code with User Defined Scalar Functions (UDSFs):

  2. import java.SQL*;
  3. import java.math.*;
  4. import com.vertica.sdk.*;
  5. public class TypesMigrationFactory extends ScalarFunctionFactory
  6. {
  7. @Override
  8. public void getPrototype
  9. (ServerInterface srvInterface, ColumnTypes argTypes,
  10. ColumnTypes returnType)
  11. {
  12. returnType.addInt();
  13. }
  14. @Override
  15. public ScalarFunction createScalarFunction
  16. (ServerInterface srvInterface) {
  17. RETURN NEW TypesMigration();
  18. }
  19. public class TypesMigration extends ScalarFunction {
  20. @Override
  21. public void processBlock
  22. (ServerInterface srvInterface,
  23. BlockReader argReader, BlockWriter resWriter)
  24. throws UdfException, DestroyInvocation {
  25. do {
  26. Long g = NULL;
  27. INTEGER p = NULL;
  28. BigDecimal j = NULL;
  29. DOUBLE i = NULL;
  30. j = NEW BigDecimal(10);
  31. resWriter.setLong(1);
  32. }while(argReader.NEXT());
  33. }
  34. }
  35. }

You should compile the into a class file, so that you could include it in your Java UDF JAR library. If you are using a Vertica node as a development system, you can either copy the file to another location on your host, or compile it in place if you have root privileges.

Why Ispirer MnMTK?

Ispirer MnMTK helps to automate the migration process of Oracle PL\SQL to Vertica database. The tool is constantly evolving and can be easily customized for your migration project. With Ispirer MnMTK you eliminate most of the associated risks and considerably reduce internal efforts. All these benefits are available at very reasonable and competitive costs, which makes Ispirer MnMTK even more attractive instrument for this project type.

For more detailed information about our engagement model for application conversion projects, please, go to Application Migration Engagement Model page.

Live Presentation

Ispirer Migration Solution

Oracle PL/SQL to Vertica


Request a Quote

Ispirer Migration Solution

Oracle PL/SQL to Vertica

Service Toolkit

You are also welcome to reach us via Contacts page.

December 3, 2012Epicor Software Corporation, United States
Progress 4GL to C#.Net Migration

"Epicor has engaged with the Ispirer team to create and refine prototype techniques for migrating certain parts of the Epicor Progress ABL code to well...


Case Studies
May 26, 2014COBOL to .NET Conversion, United States

Our client was a major player in market-driven innovation and science. For more than two hundred years, it has been presenting world-class science and engineering to the global marketplace...


September 12, 2014Delphi to C# .NET, United States

Our client was a U.S.-based health insurance company providing care services since six decades through its extensive network of hospitals and other institutions.



The team has run few code conversion. It’s a very powerful and friendly tool.

Read more
Industry Events