Is there any limitations on OracleDataAdapter.fill method? RRS feed

  • Question

  • User1778228744 posted



    I am having peculiar problem and I am unable to find the solution. I am using stored procedure for pulling the data and using OracleDataAdapter I am filling datatable. But it is not filling all the data that I require. Actually table is having 40 records and I have received only 20 records. Whereas same stored procedure when I call in other languages Java/Delphi I am getting all the data.


    So i would like to know what are the limitations and how to resolve this issue?


    Thanks & Best Regards

    Sudhakar Chavali

    Wednesday, January 25, 2012 10:17 AM

All replies

  • User269602965 posted

    I routinely use Oracle Data Adpater to pull hundreds of records with usually about 10 columns.

    Can't help with the resolution of issue until you show some code calling the stored proc and the stored proc.

    Wednesday, January 25, 2012 8:23 PM
  • User-224007220 posted

    I believe there is no such limitation on the OracleDataAdapter... As Lannie said, without code example it's hard to tell where is the problem.

    Wednesday, January 25, 2012 8:29 PM
  • User1778228744 posted


    Below is the code that we are using,for pulling the records. In stored procedure there is nothing  much written it is pretty striaght forward query as you see in below code (Select * from BRANCH)

    Note that Requery and FetchSize I have used, assuming if they could help me. But they did not help me.


     Datatable Load()
                DataSet BranchCollection = new System.Data.DataSet();
                    String dbConnectionStatus = DatabaseConnection.getDBConnection();
                    if (dbConnectionStatus == "Connected")
                        OracleCommand command = DatabaseConnection.connection.CreateCommand();
                        command.CommandType = CommandType.StoredProcedure;
                        command.CommandText = "pkg_master.usp_view_branch";
                        OracleParameter paramOut = new OracleParameter("o_rs_branch", OracleDbType.RefCursor, System.Data.ParameterDirection.Output);
                       // command.CommandText = "Select * from BRANCH";
                       // command.CommandType = CommandType.Text;
                       // command.FetchSize = 1024 * 1024;
                       // OracleDataAdapter BranchAdapter = new OracleDataAdapter(command) { Requery = false };
                                  OracleDataAdapter BranchAdapter = new OracleDataAdapter(command);
                catch (Exception ex)
                return BranchCollection.Tables[0];




    Friday, January 27, 2012 9:55 AM
  • User665793701 posted

    Can u check how many data is there on the table

    Wednesday, February 29, 2012 4:38 AM