Loading packed data
I am trying to load data using sql loader. I keep getting the error below.
Problem Description
---------------------------------------------------
We are developing a load process for IBM mainframe data. It fails on the first packed decimal field.
Error Codes
---------------------------------------------------
ORA-01460: unimplemented or unreasonable conversion requested
here is the control file for said load
-- FCS_FAA_Load_01_01.ctl
--
--
-- 06/11/13 GPP project 2013-072
--
-- $Rev:: 9328 $: Revision of last commit
-- $Author:: devgreg $: Author of last commit
-- $Date:: 2013-06-19 10:45:#$: Date of last commit
--
--******************************************************************************
load data
CHARACTERSET WE8EBCDIC500
--characterset we8ebcdic500
--
-- Log File Locations
--******************************************************************************
infile 'small_test_binary.txt' "STR x'00410042'" --"STR x'0a'"