Skip to Content
-1

Oracle package Conversion to HANA

Dec 15, 2016 at 04:50 AM

136

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Denys van Kempen
Dec 15, 2016 at 03:43 PM
1

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,

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

1