Hello all,

I have a script of the format which is of the format:

BULK SELECT into X
FROM SELECT data
FROM tables
WHERE conditions
GROUP BY order

and

am getting a bizarre situation. I have narrowed it down to when I add an inner join for a table (even if that table is not used anywhere else) I get the message:

ORA-02055: distributed update operation failed; rollback required
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 120

However, if I take the select statement out (including this new table) and run it in a separate window so it is not a part of the script - it works fine and returns data.

Can anyone please suggest a way of investigating this - I am quite stumped!!!

I am using PLSQL in Oracle if that helps.