Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Any way to disable UNDO (rollback) with temporary tables?
NetComrade wrote:
>
> 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?
>
I don't know the answer to your question. But ...
The last time I had a discussion about something like this with a developer, on digging into the entire requirement we found that he didn't even need to use procedural logic - just set management and moderately advanced SQL skills.
Could you expand on what you are trying to accomplish, possibly with pseudo-code. Received on Mon Dec 01 2003 - 22:20:25 CST