Oracle Stored Procedures: Readers or Datasets?

Posts   
 
    
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 04-Jan-2022 20:11:58   

Hi Guys,

I am writing a system that talks to Oracle Stored Procedures. For the ones that return cursors, LLBL gives me 2 options. Readers and Datasets/DataTables.

Is there a general rule I should follow in choosing between Readers and Datasets to get data back? Results size etc?

Ian

Walaa avatar
Walaa
Support Team
Posts: 14855
Joined: 21-Aug-2005
# Posted on: 05-Jan-2022 18:22:33   

Please read DataReaders and Projections I'd always go for DataSets, unless there is a specific requirement for having a DataRader as explained in the first section of the documentation.

ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 05-Jan-2022 20:36:22   

Perfect, thanks