PLS-00123: program too large (Diana nodes)

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
bhav27
Posts: 20
Joined: Tue 20 Apr 2010 11:53

PLS-00123: program too large (Diana nodes)

Post by bhav27 » Tue 04 May 2010 14:49

Hi
I get above error when my SSIS package tries to insert 1800 + records into the database. Does anyone have a clue to this problem?

bhav27
Posts: 20
Joined: Tue 20 Apr 2010 11:53

Post by bhav27 » Wed 05 May 2010 14:53

I solved this problem by setting the batch size to 200

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 06 May 2010 09:23

This is the expected error for SSIS inserting a large batch. Glad to see that the problem was resolved.

Post Reply