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?