Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> ref cursor
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
Received on Fri Aug 18 2000 - 15:27:56 CDT