Is there any limitations on OracleDataAdapter.fill method?

Question

User1778228744 posted

Hi

 

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

Answer 1

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.

Answer 2

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.

Answer 3

User1778228744 posted

Hi

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();
            try
            {
                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.Parameters.Add(paramOut);
                   // 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);



                   
                    BranchAdapter.Fill(BranchCollection);
                   
                 
                   
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
            }
            finally
            {
                DatabaseConnection.FlushConnections();
            }
            return BranchCollection.Tables[0];
        }

 

 

 

Answer 4

User665793701 posted

Can u check how many data is there on the table