Last post Sep 26, 2010 08:51 PM by Lannie
Sep 25, 2010 02:07 AMfirstname.lastname@example.org|LINK
i am trying to upload an excel to an oracle data base (10g xe) the excel has arround 46000 rows.
I am getting the following error when i do a insert
ORA-06550 string 1 line 1,
PLS-00123: program too large (Diana nodes)
can some body please help
Sep 26, 2010 08:51 PM|Lannie|LINK
If you are trying to cut and paste Excel .XLS worksheet cells into Oracle 10gXE there is a 30 kilobyte limit.
Given that limitation, I would export the Excel worksheet to TAB delimited flat file,
then use the Oracle 10gXE file upload utility to parse and insert the tab delimited data into a NEW TABLE option.
When importing into an existing table, the data types have to match or you will get load errors.