DBMS_PIPE INTERMITTANT ORA-06559 WRONG DATATYPE REQUESTED, 9 , ACTUAL DATATYPE 6

Hi Team,

We are facing  Intermittantly the ora-06559 error,

This causes currently 1 to 2 errors monthly in production causing application outage.

The pipes are called from a trigger.

So as a workaround we disabled the trigger to assure the activity continuity.

So we need to find the root cause of the issue and to fix it definitively. 

Br.