Question

2
Replies
966
Views
Michael Finlay (MichaelF1903)
CYBG

CYBG
GB
MichaelF1903 Member since 2012 26 posts
CYBG
Posted: June 15, 2018
Last activity: June 25, 2018
Posted: 15 Jun 2018 11:06 EDT
Last activity: 25 Jun 2018 6:32 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.