You must Sign In to post a response.
  • Category: ASP.NET

    How to insert around 15000 records from asp.net to Oracle

    Dear All,
    I am working one of leading bank in UAE, one of my requirement is bulk salary upload(xls) through internet banking, need to insert around 15000 records asp.net application to Oracle, I am getting connection error in between. provide better approach to implement this same.


    appreciate you guys to earlier response.

    Advance Wishes!!!
  • #763560
    Hi Ramesh,

    For Banking application you need to take care the performance, while inserting 15000 records you got timeout error, this is happens because the application takes more time to execute( insertion ) the program. I request you to please do code optimization through out application and then recheck it once.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #763565
    How you are uploading. Parsing the excel and and inserting the records one by one?

    If not you can try that. If you share your code that will be easy for identify the issue.

    By Nathan
    Direction is important than speed

  • #763595
    Unlike SQL in Oracle there is no bulkcopy class exist as far as I know somewhere I read about OracleBulkCopy, but with the help of Array Binding, here Oracle passes the parameter arrays from .NET to the database in one go, and then repeatedly invokes the stored procedure you specify using the parameter values you specified
    check out following link for more information
    http://stackoverflow.com/questions/343299/bulk-insert-to-oracle-using-net

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #763603
    Hi Prasad Kulkarni,
    Thank you so much for the information. The link, you provided very helpful for me.

  • #763702
    I am inserting one by one, do we have option bulk insert from asp.net to oracle?


Sign In to post your comments