RE: ref cursor

The biggest problem I ran into when I did this a couple years ago (Oracle 7.3.4) as an extremely high number of consistent changes on the table -- which causes tons of rollback.

To get around the problem I had to build the end result in a PL/SQL Table (10-100k rows), do a quick insert into the table, commit and return the REF CURSOR. When the front-end app was finished selecting from the REF CURSOR, it called a procedure that deleted the rows.

We also scheduled a weekly on-line rebuild of the indexes on the table.

Hope this helps.
Kevin

>
> Hi List,
> Here is a scenerio ,I have a stored proc which inserts the
> records in a temp table and creates a ref cursor based on
> this ,the cursor is returned as out parameter ,after that
> proc deletes the records from the table and then commits
> it.(Finally i have nothing in database)
> Now when the calling program will try to fetch records from
> the ref cursor will it have any problem ??
> Do you see any potential problem here if millions of users
> are accessing this simultaneously.
>
> Ideas wellcome ..
> Thanks
> Ajay K
> --
> Author:
> INET: ajay_at_tems.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Aug 21 2000 - 06:23:39 CDT