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?
We've accomplished passing an array of objects, but one element (of an
array) at a time.
We've also accomplished passing back arrays, but not of objects.
On Tue, 02 Dec 2003 03:54:26 GMT, "Anurag Varma" <avdbi_at_hotmail.com> wrote:
>
>"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
>
>
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Received on Tue Dec 02 2003 - 10:20:44 CST