Hello folks,kind of running out of ideas on this one.
We have a job,which runs an ssis package to collect data from an oracle source & import it into our system.
Package works fine in bids,nothing has changed to the connector,provider whatever you can think off but it started failing with the following messages:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error character string buffer too small.
ORA-06512: line 21
We have changed nothing to the environment.