RE: anyone using bulk collection in pl/sql

From: Michael Fontana <>
Date: Tue, 17 Feb 2009 08:39:37 -0600 (CST)
Message-ID: <>

You may want to look at the character set values for the source database. See the following article: ue-only-for-insert-into-a-long-column/  

From: [] On Behalf Of
Sent: Tuesday, February 17, 2009 8:26 AM To:
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 on solaris 10.

thanks, joe

Joe Testa, Oracle Certified Professional Senior Consultant
Data Engineering and Administration
Nationwide Investments

(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage? Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.

Received on Tue Feb 17 2009 - 08:39:37 CST

Original text of this message