Burak, Instead of a cursor it's the type of object you cast the returned records into. A datareader is a forward only set of records, it reads until the end and then you are done. The benifit of this is a somewhat lighter object which you close the connection to once you are finished reading the contents. A datatable is a slightly heavier object and can go forwards and backwards in the records but is not directly linked to database, therefor you will need to create methods to handle the various stored procedures of selecting, updating and deleting the data from the database. The connection to the database can be freed once you have retrieved the data into the datatable. As apposed to say a dataset in conjection with dataadapters and dataview are slightly heavier object than a datatable which enables you to update it directly via data adapters with a single call with the dataset as an arguement. The benifit from this is that you can have a series of adapters each containing tables from the db with the appropriate select, delete, and update methods which handle all the transaction of the data. With a dataset you can go backwards and forwards, reference the entire schema of you database, and enforce the constraints you have on the db. The connection to the database can be freed after you have completed the datamanipulation in the dataset. While this is a more robust solution it does have it's limitations, it the choice in desktop stand alone applications. Datatables are the good for both web and desktop applications and you'll find it versatile enough for going backwards and forwards in data. Datareaders can also be used in web and desktop applications but like I said before it's main draw is that it is forward only and is light weight. I hope this helps, and if you have any further questions please feel free to contact me. Regards, Shannon
--- Burak Gunay <[EMAIL PROTECTED]> wrote: > > Hello, > > I have an oracle stored procedue that returns a > cursor > > PROCEDURE GetNumTitleUniqueFamilies > ( word in varchar, src in varchar,onetfam in > varchar, > wordrows out types.word_cursor_type) as > begin > open wordrows for > select distinct substr(ONETCODE, 1, 2) from > PROCESSEDWORDS > where WORD = word > and SOURCE = src > and ( TITLEMAXOCCURENCE is not null and > TITLEMAXOCCURENCE > 0 ) > and substr(ONETCODE,1,2) != onetfam; > end GetNumTitleUniqueFamilies; > > I found a page that shows how to call a stored > procedure that returns a cursor > > > http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3B308073 > > but I was wondering how I would add an output > parameter if I want to call it in the following > manner > > strSelect = "GetNumTitleUniqueFamilies" > cmdselect = New OleDbCommand(strSelect, > objConnSkills2) > cmdselect.CommandType = > CommandType.StoredProcedure > cmdselect.Parameters.Add("word", > OleDbType.VarChar).Value = strWord > cmdselect.Parameters("word").Direction = > ParameterDirection.Input > cmdselect.Parameters.Add("src", > OleDbType.VarChar).Value = strSource > cmdselect.Parameters("src").Direction = > ParameterDirection.Input > cmdselect.Parameters.Add("onetfam", > OleDbType.VarChar).Value = strOnetFamily > cmdselect.Parameters("onetfam").Direction = > ParameterDirection.Input > > since there is no OleDbType.Cursor type. > > Thank you, > > Burak > > > > > __________________________________ > Do you Yahoo!? > Take Yahoo! Mail with you! Get it on your mobile > phone. > http://mobile.yahoo.com/maildemo > __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
