-
October 31st, 2011, 06:35 AM
#1
Unexpected error message
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|