Skip to Content

Call Stored Procedure From Remote HANA System

Hello,

In my scenario, I have two HANA DBs connected to each other via SDI:

HDB1 -> HDB2

I have written a stored procedure in HDB1, and I would like to know if it is possible, from the stored procedure in HDB1, to call another stored procedure in HDB2.

Thank you,

Marcelo

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Aug 23, 2018 at 04:50 AM

    No, it is not possible to call a procedure on your HDB2 from within a procedure on your HDB1. Interactions have to be done (at least at the moment) on a higher layer, e.g. a service on HDB1 uses a service from HDB2 which uses your procedure on HDB2.

    Also the available VIRTUAL PROCEDURE option will you not help, because it supports no SQLScript procedures until now.

    The Synonym approach suggested in the other answer is also not supported, cause the "database" option in a synonym is not valid for procedures (only for views and tables). In addition the synonym option would only work for a cross tenant database access in a multi database container system (I assume your both mentioned databases are not just tenant databases within the same HANA MDC system).

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2018 at 05:06 PM
    -1

    Hello Marcelo Berger,

    Have you tried to use synonyms for it?

    BR,

    Pacheco.

    Add comment
    10|10000 characters needed characters exceeded