What might be causing this ORA buffer error in Informatica?
Posted on 2011-03-11
A particular Informatica session is commonly experiencing the following error:
ORA-24306: bad buffer for piece
The common belief seems to be that this is an Informatica problem, not an Oracle problem. Granted, we are reading in some very large columns as part of the session. Certainly there are memory mismanagement issues.
That said, how is it possible that the Oracle side can report a buffer problem, and the problem exist in Informatica? In other words, how can Oracle throw this error UNLESS the problem is in Oracle alone?