[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: ORA-01453 SET TRANSACTION ERROR



I might be way off-base here, but shouldn't there be a begin-program /
end-program paragraph with 'do get_rollback' there instead of
begin/end-report?

> ----------
> From:         Duncan Berriman[SMTP:Duncan.J.Berriman@ITSERVICES.CO.UK]
> Reply To:     SQR-USERS@USA.NET
> Sent:         Tuesday, July 07, 1998 9:15 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: ORA-01453 SET TRANSACTION ERROR
>
> 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
>