Re: ORA-01453 SET TRANSACTION ERROR

["Derry, Denny" <Denny.Derry@NMB.NORWEST.COM>]

     Try using the -xp option in your begin-sql statement.
     Without this SQR creates procedures on the server
     for your query.

     i.e.
     begin-sql -xp
     set transaction

     rest of code
     end-sql


     Just a guess.
     -Denny


______________________________ Reply Separator
_________________________________
Subject: Re: ORA-01453 SET TRANSACTION ERROR
Author:  Duncan Berriman [SMTP:Duncan.J.Berriman@ITSERVICES.CO.UK]  at
NMB
Date:    7/7/98 9:15 AM


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