Oracle Enterprise stage
Posted: Wed Jun 18, 2008 7:31 am
Hi,
we are trying to load a cobol file into a oracle table (with 600 columns in table).we just Insert rows into the table.
We use the write Method Upsert and then select the Upsert mode as 'User defined update only',and write the Insert statement in there.But since table has many columns the whole insert
statement does not fit in the space assigned.
Any idea how to over come this issue.
I am unable to use the Write Method as Load as we do not have the sql loader set up.
Thanks
we are trying to load a cobol file into a oracle table (with 600 columns in table).we just Insert rows into the table.
We use the write Method Upsert and then select the Upsert mode as 'User defined update only',and write the Insert statement in there.But since table has many columns the whole insert
statement does not fit in the space assigned.
Any idea how to over come this issue.
I am unable to use the Write Method as Load as we do not have the sql loader set up.
Thanks