Hi,
I am using Oracle enterprise stage for loding data into an oracle table and selected
write method = 'LOAD' and
write mode = APPEND
the job was aborting.
1. I was just wondering what would be the best practice/write method to choose for Inserts in DS 8.x
2. Can i use 'LOAD' method to do inserts (if so please be specific)
Appreciate your help
Oracle Enterprise stage issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Re: Oracle Enterprise stage issue
What is the error message you are getting.?
you can use write 'LOAD' method to do inserts.
if you are directly loading data into tables from legancy then 'LOAD' method to do inserts is the best practice.
Cheers,
NepalReddy
you can use write 'LOAD' method to do inserts.
if you are directly loading data into tables from legancy then 'LOAD' method to do inserts is the best practice.
Cheers,
NepalReddy
Thanks,
Chris Jones
Chris Jones
chulett wrote:You need to be the specific one here, otherwise the answer to the "Can I?" question is just "yes". What caused your job to abort? What errors were logged? ...
We were actually trying to do Inserts using Oracle Enterprise stage with write method = 'Load' and mode = Append
and the job was getting aborted.
Here is the error message:
Error when checking composite operator: Caught parsing exception during wrapDescribeOperator(): Parsing parameters "0" for schema type "ustring": Length must be positive, got: "0"
Could not find type: ustring[0]