Automated Application Conversion
Do you need to convert your Oracle PL/SQL application to Java? In this case, Ispirer products will be the perfect solution for your project!
Human-written code in each project has its own specifics. It may seem difficult to obtain a high level of automated conversion. With Ispirer it will be a smooth transition. The main advantage of Ispirer Toolkit is the personalization for your conversion project. As a result, you will replace the old technology with all its downsides. The outcome will be a new application without any middleware used afterwards.
How it Works
Ispirer Toolkit
Automated conversion of Oracle PL/SQL to Java with the help of our tool makes it possible to significantly reduce the time and expenses as compared to manual rewriting of the application. The following approach allows to ensure high quality of automated conversion:
1. Preliminary Stage
The stage is carried out to determine the current conversion level of Ispirer Toolkit. The level of conversion depends on the complexity of the source code and the requirements for the target application. You can independently perform the analysis of the source code of your Oracle PL/SQL application, as well as try to convert it to Java using the demo license. Besides, our experts can perform the source code analysis and provide you with examples of its conversion.
If your application is quite specific and large, we recommend to perform PoC to determine the maximum level of automated conversion of your project.
As a result, we will find out whether the customization is required or you can directly proceed to the conversion.
2. Ispirer Toolkit Customization Stage
If this stage is necessary, we will perform the customization to thoroughly prepare the toolkit for the conversion according to your project requirements. We will take a part of a representative code that amounts ussually to ~100,000 lines. The Ispirer technical team will add all the required conversion rules into the tool to achieve the highest possible level of automation or even to get a compilable result. As a delivery, we will provide conversion results of the scope of this customization. The customer will get a tailored and updated tool according to his specific project needs.
3. Use of Ispirer Toolkit
At this stage, you perform the conversion yourself. As to pricing, we apply project-based licensing. Prices depend on its scope and duration. The license includes support as well. If necessary, the conversion may be further improved even at this stage. As a result, customization requests, each of which is processed within 1-3 business days, are added to the license. Our experts will recommend the optimal number of requests considering the complexity and requirements of your project.
Ispirer Toolkit 10
Oracle PL/SQL to Java
Free Demo License
Try Now
Ispirer Migration and Modernization Service (Ispirer Service)
Our experienced team can provide you with a turnkey migration service and convert your entire Oracle PL/SQL application to Java, delivering you a ready-to-use application in due time. Our responsibilities include not only professional analysis, assessment, performance and testing of your migration, but also services such as adding new or changing existing functionality of the application.
If you want to get an intermediate result of the converted Oracle PL/SQL code in the Java language, the Ispirer team will be glad to provide you with a basic migration service. As a result, you will get code that is optimized to the compilable level. Further, you will have to independently bring the application to a fully functional state in accordance with your requirements.
You are free to choose a preferred option. Nevertheless, we can provide an estimate of both the Tool and the Service, and give professional advice.
Conversion Overview

Ispirer Toolkit automatically converts Oracle PL/SQL to Java, considering the specifics of these languages. Both conversion with connection to the source database, as well as conversion of files containing PL/SQL scripts are possible. Our tool supports conversion of the following objects: packages (specification and body), collection and object types, functions, procedures. At the same time, tables, views, triggers and sequences remain on the side of Oracle. As a result of conversion, each separate database object is converted to a Java class. Class names are formed based on object names, taking into account the Java Naming Convention.
In case, you need your Java application to work with a different database, Ispirer Toolkit can convert Embedded SQL and the database itself.
Variable Conversion
Ispirer Toolkit automatically converts function and procedure variables (nested or not) to method variables, as well as package variables to class variables. The tool supports conversion of all Oracle data types. Moreover, when converting variables, their visibility is taken into account.
Code Conversion
Procedures and functions are converted to classes with one method. Packages are converted to classes, their nested functions and procedures into methods of this class, taking into account their visibility. Initialization block is converted to the class constructor. Oracle built-in functions and procedures are converted either to the same Java methods, if any, or to the methods of our Plsqlutils helper class.
Working with Database
Oracle SQL Statements can be converted to JDBC, Hibernate, Spring JDBCTemplate. In addition, we have implemented the ability to export SQL statements to XML files for their support optimization. Besides, the logic of working with cursors is transferred to Java.
Working with Collections
Ispirer Toolkit supports collection conversion of all three types: Associative array, Nested table, Variable-size array (varray). For optimal collection conversion, we have developed helper classes that allow to repeat the logic of Oracle collections in Java.
Oracle Supplied PL/SQL Package Conversion
Ispirer Toolkit supports conversion of some Supplied PL/SQL Packages, such as UTL_FILE, DBMS_LOB and others. The list can be expanded based on the requirements of your conversion project.
Oracle PL/SQL to Java Conversion Demo
Check out how Ispirer Toolkit automatically converts Transact-SQL application.
Drop us a line, if you have any business inquiries or questions regarding your Oracle PL/SQL conversion project. Ispirer experts will demonstrate our solutions and answer any questions you may have!
Contact usConversion Samples of Oracle PL/SQL to Java
Ispirer Toolkit analyzes all object dependencies during the conversion process and provides not only line-by-line conversion, but resolves type conversions as well. In addition, the software understands and transforms the necessary inheritance dependencies. It parses the entire source code, builds an internal tree with all the information about the objects, and uses it in the migration process. For more information review the code samples below.
Common variables declaration structure conversion:
Oracle PL/SQLJava
package com.ora;
import java.math.*;
public class Pkgwithvars {
private static final org.slf4j.Logger LOGGER = org.slf4j.LoggerFactory.getLogger(Pkgwithvars.class);
private String inst
= "pkgWithVars"; return inst;
}
public void setInst
(String inst
) { this.inst = inst;
}
try {
myStatus = NORMAL.setScale(0, RoundingMode.HALF_UP).intValueExact();
}
LOGGER.
error(String.
valueOf(e
)); throw e;
}
}
}
%ROWTYPE attribute and Record Type conversion:
Oracle PL/SQLJava
);
rec2 rec2_tp;
rec1.PREC_ID := v1;
v1 := rec2.inst_id;
public class PrecTab {
return precId;
}
this.precId = precId;
}
return precSt;
}
public void setPrecst
(String precSt
) { this.precSt = precSt;
}
return cnt;
}
this.cnt = cnt;
}
public PrecTab() {
}
this.precId = precId;
this.precSt = precSt;
this.cnt = cnt;
}
public PrecTab(PrecTab prectab) {
this.precId = prectab.precId;
this.precSt = prectab.precSt;
this.cnt = prectab.cnt;
}
}
public class Example {
private static final org.slf4j.Logger LOGGER = org.slf4j.LoggerFactory.getLogger(Example.class);
private static class Rec2Tp {
return instId;
}
this.instId = instId;
}
return instrDt;
}
this.instrDt = instrDt;
}
public Rec2Tp() {
}
this.instId = instId;
this.instrDt = instrDt;
}
public Rec2Tp(Rec2Tp rec2Tp) {
if (rec2Tp != null) {
this.instId = rec2Tp.instId;
this.instrDt = rec2Tp.instrDt;
}
else {
this.instId = null;
this.instrDt = null;
}
}
}
public void spQuickfileSql
() throws Exception { try {
PrecTab rec1 = new PrecTab();
Rec2Tp rec2 = new Rec2Tp();
rec1.setPrecId(v1);
v1 = rec2.getInstId();
}
LOGGER.
error(String.
valueOf(e
)); throw e;
}
}
}
For collection types conversion we’ve implemented additional classes that have same behavior as Oracle collections:
Oracle PL/SQLJava
student_array student_arraytype;
AssociativeCollection
< Integer, Student
> studentArray
= new AssociativeCollection
< >( Integer.
class,
new Student
());
for (int i = studentArray.first(); i <= studentArray.last(); i ++) {
System.
out.
println(studentArray.
get(i
).
firstName); }
Cursor conversion (JDBC):
Oracle PL/SQLJava
Student studRec = new Student();
try(PreparedStatement stResCStud
= mConn.
prepareStatement("SELECT * FROM STUDENT"); ResultSet rsResCStud
= stResCStud.
executeQuery();) { while (rsResCStud.next()) {
studRec.setStudentid(rsResCStud.getString(1));
studRec.setLast(rsResCStud.getString(2));
studRec.setFirst(rsResCStud.getString(3));
studRec.setBirthdate(rsResCStud.getTimestamp(4));
studRec.setFacultyid(rsResCStud.getInt(5));
studUpdate(studRec);
}
}
Cursor conversion (Spring JDBC):
Oracle PL/SQLJava
SqlRowSet rsCStud = null;
try {
Student studRec = new Student();
rsCStud = jdbcTemplate.queryForRowSet("SELECT * FROM STUDENT");
do {
fsCStud = rsCStud.next();
if (Boolean.
FALSE.
equals(fsCStud
)) { break;
}
studRec.setStudentid(rsCStud.getString(1));
studRec.setLast(rsCStud.getString(2));
studRec.setFirst(rsCStud.getString(3));
studRec.setBirthdate(rsCStud.getTimestamp(4));
studRec.setFacultyid(rsCStud.getInt(5));
studUpdate(studRec);
}
while (Boolean.
TRUE.
equals(fsCStud
)); }
LOGGER.
error(String.
valueOf(e
)); throw e;
}
Cursor conversion (Hibernate):
Oracle PL/SQLJava
List
<Object[]> cStudList
= null;
try {
Student studRec = new Student();
cStudList = session.createNativeQuery("SELECT * FROM STUDENT").list();
do {
itrCStud = cStudList.iterator();
fsCStud = itrCStud.hasNext();
if (!fsCStud) {
break;
}
Object[] objCStud
= itrCStud.
next(); studRec.
setStudentid(QueryUtility.
toObject(objCStud
[0],
String.
class)); studRec.
setLast(QueryUtility.
toObject(objCStud
[1],
String.
class)); studRec.
setFirst(QueryUtility.
toObject(objCStud
[2],
String.
class)); studRec.
setBirthdate(QueryUtility.
toObject(objCStud
[3],
String.
class)); studRec.
setFacultyid(QueryUtility.
toObject(objCStud
[4],
String.
class)); StudUpdate.spStud_update(studRec);
}
while (fsCStud);
cStudList = null;
}
LOGGER.
error(String.
valueOf(e
)); throw e;
}
Output parameters conversion:
Oracle PL/SQLJava
PAR_SAJES_OUT
OUT sys_refcursor
)
V_SAJES open_cursor;
proc_test(V_ID, V_SAJES);
RowSetFactory rowSetFactory = RowSetProvider.newFactory();
Map
<String, Object
> outData
= new HashMap
<>(); CachedRowSet parSajesOut = rowSetFactory.createCachedRowSet();
Connection mConn
= JDBCDataSource.
getConnection();
try {
parSajesOut.release();
parSajesOut.populate(rs);
}
}
SQLCursorHandler.getInstance().handleExeption(se);
throw se;
}
if (!mConn.getAutoCommit()) {
mConn.commit();
}
return outData;
}
LOGGER.
error(String.
valueOf(e
)); throw e;
}
finally {
outData.put("par_id", parId);
outData.put("par_sajes_out", parSajesOut);
if (mConn != null) {
mConn.close();
}
}
}
try {
OpenCursor vSajes = new OpenCursor();
ProcTest.spProc_test(vId, vSajes);
}
LOGGER.
error(String.
valueOf(e
)); throw e;
}
}
Nested procedure conversion:
Oracle PL/SQLJava
W_PAR := '1';
W_TOBE := '1';
CHK;
CHECK1;
public void spPkgNestedExample
() throws Exception { class NestedFunctions {
public void check1
(MutableObject
<String
> mutablewTobe, MutableObject
<String
> mutablewPar
) throws Exception { String wTobe
= mutablewTobe.
getValue(); String wPar
= mutablewPar.
getValue();
try {
wPar = "1";
wTobe = "1";
}
LOGGER.
error(String.
valueOf(e
)); throw e;
}
finally {
mutablewTobe.setValue(wTobe);
mutablewPar.setValue(wPar);
}
}
}
try {
NestedFunctions nestedFunctions = new NestedFunctions();
MutableObject<String> mutablewTobe = new MutableObject<>();
MutableObject<String> mutablewPar = new MutableObject<>();
mutablewTobe.setValue(wTobe);
mutablewPar.setValue(wPar);
nestedFunctions.check1(mutablewTobe, mutablewPar);
wTobe = mutablewTobe.getValue();
wPar = mutablewPar.getValue();
}
LOGGER.
error(String.
valueOf(e
)); throw e;
}
}
Download Sample Code
You have just examined only a piece of the Oracle PL/SQL to Java conversion sample. You can download the entire application migration sample for free by filling out the form. Once you get the code sample, you will be able to:
See for yourself that Ispirer Toolkit can automatically convert not only a single piece of code, but an entire application. Most likely, complex code will require customization of the toolkit, but our experts can add new conversion rules within 3-5 business days. As a result, using Ispirer Toolkit you will get readable and maintainable code of manual conversion quality in the shortest time possible.
Snatch a totally free opportunity to see the high efficiency of Ispirer Toolkit!
Get a Quote
Ispirer Toolkit
Reach the maximum level of automation and quality of your conversion with the help of Ispirer Toolkit! Based on your requirements, the Ispirer team will process all customization requests for your Oracle PL/SQL to Java conversion project. We offer several types of Ispirer Toolkit licenses, among which you will find the one that is suitable for you. Each conversion project is considered and discussed separately, prices depend on its scope, duration and complexity.
Ispirer Service
If you don't want to involve your own resources to move the Oracle PL/SQL application to Java, get Ispirer Migration and Modernization Service and we will deliver you an operational and high-quality end-result on time and at a reasonable price. Apart from professional Analysis, Evaluation, Performance and Testing of your migration, we also provide such services as Code Refactoring, Changing Functionality, and Adding Extra Functionality. Each conversion project is reviewed and discussed separately and the final price is a subject to negotiation.
Benefits You Get
100% Automation
Due to the customization, the manual work after migration will be minimized or eliminated.
Flexible Pricing
You pay for only what you need: prices depend on the scope and duration of your project.
Optimized Migration
You get an intelligent and maintainable code without using any middleware after conversion.
What Our Customers Say
"Beckman Coulter provided as much of the information as we could but there was a lot of functionality that we did not know. This is where Ispirer talents became apparent as they forensically reengineered functionality."
"We are now successfully running live on the new system, with the updated PB apps. I want to express my thanks to Ispirer team. You made this project a success!!! I was happy to work with you and would highly recommend Ispirer!"
"Because of Ispirer and MnMTK, our team was able to devote its time to build the infrastructure for new Java programs instead of spending time on converting code. The produced Java code met all our maintainability, readability and performance requirements."
"This approach was very successful avoiding any confusion at the first stage, and achieved high conversion rate in the end. The project was completed successfully, they say they couldn't make it without MnMTK 2017 and excellent extension support from lspirer."
"At the onset of the engagement the Ispirer MnMTK was expanded to meet the specific requirements of our migration prior to being delivered for our use. Once this phase of the project was complete we were provided with the expanded toolkit."
"We have found the Ispirer team to be knowledgeable and responsive and we have found the tooling to be flexible enough to be easily adapted to our coding conventions."
