RE: anyone using bulk collection in pl/sql
Date: Tue, 17 Feb 2009 08:39:37 -0600 (CST)
You may want to look at the character set values for the source database. See the following article:
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of TESTAJ3_at_nationwide.com
Sent: Tuesday, February 17, 2009 8:26 AM To: oracle-l_at_freelists.org
Subject: anyone using bulk collection in pl/sql
I'm running into an ORA-1461 error while loading data via bulk collection. I"ve dumped out all of the strings and none of them exceed any of the stated lengths in the in-memory table or the "real" table.
oracle 18.104.22.168 on solaris 10.
Joe Testa, Oracle Certified Professional Senior Consultant
Data Engineering and Administration
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.