anyone using bulk collection in pl/sql
From: <TESTAJ3_at_nationwide.com>
Date: Tue, 17 Feb 2009 09:25:30 -0500
Message-ID: <OFB0D1607A.F3E16904-ON85257560.004F1AF5-85257560.004F3D23_at_lnotes-gw.ent.nwie.net>
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.
Joe Testa, Oracle Certified Professional Senior Consultant
Data Engineering and Administration
Nationwide Investments
Date: Tue, 17 Feb 2009 09:25:30 -0500
Message-ID: <OFB0D1607A.F3E16904-ON85257560.004F1AF5-85257560.004F3D23_at_lnotes-gw.ent.nwie.net>
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 9.2.0.8 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 17 2009 - 08:25:30 CST