Skip to Content
avatar image
-1
Former Member

Oracle package Conversion to HANA

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.

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    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?

  • Get RSS Feed

1 Answer

  • Dec 15, 2016 at 03:43 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded