Question
CYBG
GB
Last activity: 25 Jun 2018 6:32 EDT
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.