Re: Rollback Segments
From: <sstephen_at_us.oracle.com>
Date: Sat, 27 Feb 1993 01:04:03 GMT
Message-ID: <1993Feb26.170403.1_at_us.oracle.com>
Date: Sat, 27 Feb 1993 01:04:03 GMT
Message-ID: <1993Feb26.170403.1_at_us.oracle.com>
In article <1993Feb22.225349.21118_at_scammell.ecos.tne.oz.au>, srh_at_scammell.ecos.tne.oz.au (Shane Hocking) writes:
>
> I am aware of the command in SQL*Plus that will make a transaction use a
> nominated rollback segment...ie SET TRANSACTION USE ROLLBACK SEGMENT rb_name
>
> Can a similar thing be done in a PRO*C program???????
>
> Regards Shane
> --
> ----------------------------------------------------------------------------
> Shane Hocking Email : srh_at_scammell.ecos.tne.oz.au
> Information Technology Department
> Information Technogogy Group
--
SET TRANSACTION ... is an SQL statement, not SQL*Plus.
EXEC SQL SET TRANSACTION READ ONLY;
-and-
EXEC SQL SET TRANSACTION USE ROLLBACK SEGMENT rb_name;
...should both be valid. It should generate a "sqlcex("SET TRANSACTION...")"
in the C code. They just get executed since there is nothing to bind/describe
or anything.
================================================================================
Scott Stephens inet: sstephen.us.oracle.com
Oracle WorldWide Support Redwood City, California
Received on Sat Feb 27 1993 - 02:04:03 CET