Is there any limitations on OracleDataAdapter.fill method? RSS

• • Reply
  

  sudhakarchav...

  Member

  2 Points

  2 Posts

  Is there any limitations on OracleDataAdapter.fill method?

  Jan 25, 2012 02:17 PM|LINK

  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

  OracleDataAdapter oracle

• • Reply
  

  Lannie

  Contributor

  3724 Points

  726 Posts

  Re: Is there any limitations on OracleDataAdapter.fill method?

  Jan 26, 2012 12:23 AM|LINK

  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.

• • Reply
  

  p3tar

  Participant

  1526 Points

  238 Posts

  Re: Is there any limitations on OracleDataAdapter.fill method?

  Jan 26, 2012 12:29 AM|LINK

  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.

  "I'm just trying to give back to the community..."
  If I helped please mark my posts as "Answer". Cheers.
• • Reply
  

  sudhakarchav...

  Member

  2 Points

  2 Posts

  Re: Is there any limitations on OracleDataAdapter.fill method?

  Jan 27, 2012 01:55 PM|LINK

  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];
          }

   

   

   

  • Edited by sudhakarchavali on Jan 27, 2012 01:59 PM
  • Edited by sudhakarchavali on Jan 27, 2012 01:59 PM
  • Edited by sudhakarchavali on Jan 27, 2012 02:01 PM
• • Reply
  

  mamun22s

  Member

  537 Points

  135 Posts

  Re: Is there any limitations on OracleDataAdapter.fill method?

  Feb 29, 2012 08:38 AM|LINK

  Can u check how many data is there on the table

  Moinul Hasan
  Senior Software Engineer
  Ennovia Technologies Limited
  
  
  (Mark it as answer if it does help you!)