Skip to Content
0
Aug 07, 2023 at 11:48 AM

Execute HANA procedure via Oracle DBLINK

75 Views

I have a PUBLIC dblink created on my Oracle server to a HANA database - "HH" - using "schema1" as the user name

Using a SELECT statement like the below works

SELECT * from schema1.TAB1@HH

=========================

I have a procedure on HANA called "schema1"."test123". I have no problems executing the procedure using the SAP HANA Development Client.

However, whenever I try executing a procedure using the dblink on Oracle with the below command,an error will be generated

exec schema1.test123@HH

[Error] Execution (7: 7): ORA-06550: line 1, column 7:
PLS-00201: identifier 'schema1.test123@HH' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

I've tried various syntax variations of the command but nothing works.

Does anyone have any advice?