Re: Weird Truncate Error

On 18.02.2011 03:59, The Magnet wrote:
> I've looked this up and have gotten nowhere. We have this code in a
> stored procedure:
>
> EXECUTE IMMEDIATE 'TRUNCATE table details_tp';
>
> I get this error when the process is run via BATCH using the CRON:
> ORA-02091: transaction rolled back
>
> But, if I run it by hand, no issues. Additionally, if I put an event
> handler in there and perform a DELETE if the truncate fails, the
> delete works fine.
>
> Any thoughts? How can a truncate fail? What kind of error is that?
> It is not a locking error...... we are all kind of lost.

This is way too few information but I would point to the peculiarities of TRUNCATE not being transactional:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10006.htm#i2067571

For more detailed answers you should probably post schema, your stored procedure, Oracle version etc.

Cheers

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/