ORA-01003 no statement parsed

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ShaneMuir
Premium Member
Premium Member
Posts: 508
Joined: Tue Jun 15, 2004 5:00 am
Location: London

ORA-01003 no statement parsed

Post by ShaneMuir »

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.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”