program too large (Diana nodes)
582751Jan 6 2010 — edited Jan 7 2010Hi,
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