My Oracle Support Banner

When Passing Parameters With Properties in EXTPROC Fails With ORA-28576 ORA-06525 (Doc ID 119761.1)

Last updated on MARCH 26, 2019

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Mar-2019***

Symptoms

Some common errors using extproc are discussed with examples, specifically with passing parameters from pl/sql to external procedures and their mapping to host language variables.

You are calling an external procedure passing some 'IN' and some 'IN OUT' parameters while specifying some additional properties such as LENGTH, MAXLEN, etc. for them. You are using LENGTH, MAXLEN to store current length and maximum
length of a formal parameter, and INDICATOR to indicate if a parameter is null.

You get following errors: 

1. ORA-28576: Lost RPC connection to external procedure agent.
2. ORA-06525: Length Mismatch for CHAR or RAW data

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.