Re: Any way to disable UNDO (rollback) with temporary tables?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 02 Dec 2003 03:54:26 GMT
Message-ID: <S1Uyb.3261$jS3.1271@news02.roc.ny>

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:3fcbae42.3308052187_at_nyc.news.speakeasy.net...
> I kind of understand the reason behind storing undo for temporary
> tables, but in our case, I believe we just don't need it.
>
> We are using temporary tables as 'arrays', since it seems like Oracle
> cannot pass back (in bulk) arrays of objects back to Pro*C. So we do a
> lot of logic within PL/SQL, and populate a generic temporary table,
> and then fetch from it in Pro*C. However, the overhead of writing UNDO
> (and extra CPU processing that comes with it) seems unnecessary. I
> looked at various 'events', but none of them seem to offer what we
> need.
>
> Any way this could be done?
>
> Thanks
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email

I don't know much about Pro*C, but I believe that you can pass back an array to Pro*C.

Take a look around in http://asktom.oracle.com and search for "array" "pro*c"

Anurag Received on Mon Dec 01 2003 - 21:54:26 CST