Data Load to Oracle Table
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm
Data Load to Oracle Table
Hi,
I have 10 columns loading into Oracle Table, but one of the column I have hard coded as space as per requirement but Oracle is treating that column as NULL and I am not able to load the data. All my data is getting rejected.
I used Oracle Preserve Blanks ENV variable but still I am unable to load the data.
Can anyone help me out.
Thanks,
I have 10 columns loading into Oracle Table, but one of the column I have hard coded as space as per requirement but Oracle is treating that column as NULL and I am not able to load the data. All my data is getting rejected.
I used Oracle Preserve Blanks ENV variable but still I am unable to load the data.
Can anyone help me out.
Thanks,
Rajesh Kumar
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm
So, that part should be fine, so now we just need the gory details of what it is you are doing and seeing. How is this mysterious column defined, both in the job and in the target - data type, size/precision, nullability, etc? What error messages are you seeing in the log? Post them here unedited if you do rather than the 'something like this' that we get on occassion. Also let us know what the heck you mean by the very generic term 'load' - what stage are you using? What Write Method, etc, etc... et cetera.
Since we're on the other side of the Looking Glass and can't see what you are doing, you need to be as complete as possible in your problem statement, otherwise people have to guess, and I'm way too old to waste my time guessing. Especially on a Sunday.
![Idea :idea:](./images/smilies/icon_idea.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm
[quote="chulett"]So, that part should be fine, so now we just need the gory details of what it is you are doing and seeing. How is this mysterious column defined, both in the job and in the target - data type, size/precision, nullability, etc? What error messages are you seeing in the log? Post them here unedited if you do rather than the 'something like this' that we get on occassion. Also let us know what the heck you mean by the very generic term 'load' - what stage are you using? What Write Method, etc, etc... et cetera.
The column name is Alloc_Ind and the data type is char and the length is 1, nullability is NOT NULL. The job is running fine with no warnings or errors but when I put a reject link for the Oracle Enterprize stage its giving me sql code as -1400. I am using upsert method.
Thanks,
The column name is Alloc_Ind and the data type is char and the length is 1, nullability is NOT NULL. The job is running fine with no warnings or errors but when I put a reject link for the Oracle Enterprize stage its giving me sql code as -1400. I am using upsert method.
Thanks,
Rajesh Kumar
I think you're trying to insert empty string '' not a space ' ' into Oracle. Because Ora-1400 means not able to insert null into not nullable column and Oracle treats the empty string as NULL.kittu.raja wrote: the Oracle Enterprize stage its giving me sql code as -1400. I am using upsert method.
Re-check your fixed string.
Regards.
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm
-
- Premium Member
- Posts: 175
- Joined: Tue Oct 14, 2008 1:48 pm