Database Administration (MOSC)

MOSC Banner

ORA-28575 unable to open RPC connection to external procedure agent

edited Aug 11, 2020 10:38AM in Database Administration (MOSC) 3 commentsAnswered

Hi all,

We have an APEX-application that uses a call to an external library. The call is invoked from a PL/SQL package. We have multiple instances where this works fine. However one Oracle 12.1 Database on Windows is giving us problems. On that database when calling the PL/SQL package through APEX the page does not do anything except waiting for the procedure to finish. When killing the session we do find following error in APEX logfiles:

  ORA-28575 unable to open RPC connection to external procedure agent


However if we call this PL/SQL package directly from SQL*Plus then it works perfectly so that should indicate that the configuration of the external proc is correct. We tried to find out how APEX exactly is calling the external procedure but no luck so far. We can see that the user ANONYMOUS is used. When we start a SQL*Plus session and change the current schema to ANONYMOUS we still can execute the procedure without any errors and also with the desired result.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center