Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ref cursor

ref cursor

From: <ajay_at_tems.com>
Date: Fri, 18 Aug 2000 12:27:56 -0800
Message-Id: <10593.115011@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US