Re: Oracle ORA-01456 error message

drit wrote:
> Hello, all. I need help to decipher this error message (ORA-01456).
> According to the description, the cause for this error is: A non-DDL
> insert/delete/update or select for update operation was attempted. And
> the action to correct this error is to Commit (or roll back) the
> transaction, and then re-execute. But it does not seem to work. Any
> help is appreciated.

What Michel said ... and in the future

1. Include the entire message not just the part you remember.
2. Include the running code.
3. Include your version number.

You got lucky this time.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)