Unexpected error message
I have a script of the format which is of the format:
BULK SELECT into X
FROM SELECT data
GROUP BY order
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.