ORA-01003 no statement parsed
Posted: Tue Oct 31, 2006 5:38 pm
Hi Everybody
Has anyone ever encountered this error before? A search of the forum revealed one other posting but it was in the parallel forum and for a different server.
Basically we are doing an insert into Oracle using a ORAOCI8 stage using an Insert Statement. If the insert is rejected then it passed along a separate stream to attempt to resolve the error before trying to re-insert it else it is rejected as unresolvable.
About 60000 records loaded as normal but now for some reason the next 75000 are being rejected with the error ..tx_load_address: ORA-01003: no statement parsed. However the same record is then being loaded on the resolution stream using the same insert statement.
To make matters simple - I guess I will just leave my question at has anybody encountered this error before.
Has anyone ever encountered this error before? A search of the forum revealed one other posting but it was in the parallel forum and for a different server.
Basically we are doing an insert into Oracle using a ORAOCI8 stage using an Insert Statement. If the insert is rejected then it passed along a separate stream to attempt to resolve the error before trying to re-insert it else it is rejected as unresolvable.
About 60000 records loaded as normal but now for some reason the next 75000 are being rejected with the error ..tx_load_address: ORA-01003: no statement parsed. However the same record is then being loaded on the resolution stream using the same insert statement.
To make matters simple - I guess I will just leave my question at has anybody encountered this error before.