Oracle package Conversion to HANA

[former_member241108]

I have application which is built on Oracle Packages , have to move this application to HANA. Any one having past experience on how did you convert Oracle packages to SAP HANA objects?

What are all constraints , workarounds in HANA to convert packages to HANA objects? I do not see any package concept in HANA.

Appreciate any pointers.

[former_member241108]

FYI, i have platform edition of SAP HANA which is used for BW. Can i create any database level objects such as procedures, views in platform edition of SAP HANA being used for BW?

[dvankempen]

Hi,

If I understand your question correctly, you are looking for information about how to migrate an Oracle application built with PL/SQL to HANA. This could potentially be quite a bit of work as applications written in PL/SQL take advantage of all the features and functions of the Oracle database, whereas with SAP HANA you would use SQLScript and code specifically for an in-memory database with all the features and functions of the SAP HANA platform. Most of the SQL will be the same but all the DDL to create your objects, all procedures and functions will all be different.

Some time ago, I wrote this blog about SAP HANA for Oracle Developers > https://blogs.sap.com/2015/10/13/sap-hana-for-oracle-developers-by-the-sap-hana-academy/ for the playlist https://www.youtube.com/playlist?list=PLkzo92owKnVxea5sIoOY5B4xb8WTj5_g6

Maybe this will provide you with some relevant information.

Success with your project,

[former_member241108]

thanks Denys for these valuable resources, appreciate your timely response.