Question

2
Replies
816
Views
MichaelF1903 Member since 2012 26 posts
CYBG
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed
Solved

How do I call a stored procedure on an external DB?

We are attempting to run a stored procedure in an external DB that we have classes mapped to. We are qualifying the procedure name with the schema name, so we have something like the following:

\{CALL schema_name.procedure_name(
{.property1 in},
{.property2 out},
{.property3 out}
)\}

We are seeing the error: "ORA-06576: not a valid function or procedure name", which we assume is due to PRPC looking on the PegaDATA schema. We have tried prexixing the schema name with the DB name, thus:

\{CALL db_name.schema_name.procedure_name(
{.property1 in},
{.property2 out},
{.property3 out}
)\}

to no avail. How can we specify which DB to look for the stored procedure on?

Many thanks,

Mike.

Data Integration
Moderation Team has archived post
Share this page LinkedIn