RE: anyone using bulk collection in pl/sql
- From: "Michael Fontana" <mfontana@xxxxxxxxxxx>
- To: <TESTAJ3@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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:
http://vsadilovskiy.wordpress.com/2007/10/19/ora-01461-can-bind-a-long-val
ue-only-for-insert-into-a-long-column/
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of TESTAJ3@xxxxxxxxxxxxxx
Sent: Tuesday, February 17, 2009 8:26 AM
To: oracle-l@xxxxxxxxxxxxx
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 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.
Other related posts:
