Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

program too large (Diana nodes)

582751Jan 6 2010 — edited Jan 7 2010
Hi,
I am using a tool called SQL Server Integration Services (SSIS) to insert a few thousand rows of data into Oracle 10G Express. I was getting a non-descript, unhelpful error so I turned on ODP.Net tracing and found the following error in the trace file:

TIME:2010/01/03-21:27:22:963 TID:1328 (ERROR) Oracle error code=6550; Oracle msg=ORA-06550: line 7327, column 1:
PLS-00123: program too large (Diana nodes)

I've done a bit of reading up about DIANA nodes (http://www.cs.bris.ac.uk/maintain/OracleDocs/appdev.816/a77069/e_lims.htm) and found the following which seems to apply to my situation:

"With an anonymous block, the best solution is to redefine it as a group of subprograms, which can be stored in the database"

Unfortunately I do not have the option to store code in the database (for reasons I won't go into here). Does anyone have any advice as to how I can get around this?

Thanks
Jamie Thomson
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2010
Added on Jan 6 2010
17 comments
6,316 views