Re[2]: ORA-01453 SET TRANSACTION ERROR

[Richard Mitchell <richard.mitchell@GSA.GOV>]

     Sometimes, when the SQR is not working right, I can find out what gets
     'added' or not by putting an extra character just before the
     'END-SELECT'. I use an 'X' just so I can find what I added.

     Instead of getting the expected error, I get an SQL error with all
     substitution showing.

     Happy hunting,

     Rick


______________________________ Reply Separator _________________________________
Subject: Re: ORA-01453 SET TRANSACTION ERROR
Author:  "duncan berriman" <duncan.j.berriman@itservices.co.uk> at internet
Date:    7/7/98 3:15 PM


Duncan J Berriman
07/07/98 16:15


As you can see there are no other statements in my bit of test code.
The WHOLE procedure is as follows. Weird ?
Thanks
Duncan

begin-report
  do get_rollback
end-report

begin-procedure get_rollback

begin-sql
set transaction
use rollback segment RBS1
end-sql

end-procedure