Re: Read only transaction problem

cookie monster <nospam_at_nowhere.com> wrote:
> Hi,
>
> Using Oracle 9iR2
>
> I have this problem whereby I want to read from 10 tables that have FK
> and the data is always changing. Therefore I use the option SET
> TRANSACTION READ ONLY. Works fine. But now I want to read these 10
> tables and create NEW tables with consistent data (using pl/sql). The
> problem is I can't perform any insert of new data because I get an
> error that the transaction is read only.

Then use the serializable isolation level. Be warned that it is not truly serializable, but I don't think it will be a problem for your purposes.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB