Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 1 of 1

Thread: Executing Oracle Procedure

  1. #1
    Junior Member
    Join Date
    May 2010
    Posts
    6
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Post Executing Oracle Procedure

    Dear Experts,

    I am calling oracle procedure from Java class on saving records,
    this Oracle procedure contains many validations before updating values in some tables but its normally takes 10 - 20 seconds time for execution even if its executed directly from the database.

    now the calling part of this procedure is after saving bulk number of records and in this case the procedure is not executed properly for all the records, I wonder if its because of the Queue accumulation on the procedure or is it because of the incorrect way of calling the procedure

    I am writing the way I am calling the procedure

    CallableStatement proc = conn.prepareCall("{ call pro_Update_table(?) }");
    proc.setInt(1, 100);
    proc.execute();

    Note: please note that this procedure needs to be executed individually for each record, and in case if n number of records saved at once this procedure will be called n number of times

    Any suggestion will be appreciated
    Last edited by java_mein; May 14th, 2010 at 03:15 PM. Reason: More explaination


Similar Threads

  1. Help Executing C Program From Java! (Ubuntu)
    By penguinGirl in forum What's Wrong With My Code?
    Replies: 0
    Last Post: April 18th, 2010, 01:47 PM
  2. Executing Linux Commands with Java GUI
    By linuxrockers in forum AWT / Java Swing
    Replies: 2
    Last Post: February 15th, 2010, 10:57 PM
  3. Problem with a waitFor() executing a script
    By Baldurian in forum What's Wrong With My Code?
    Replies: 2
    Last Post: January 29th, 2010, 10:45 AM
  4. [SOLVED] installation procedure for java 1.6 latest version on xp
    By sriraj.kundan in forum Java Theory & Questions
    Replies: 1
    Last Post: June 25th, 2009, 08:18 AM
  5. [SOLVED] Detecting whether the piece of code is executing?
    By vivek1982 in forum Web Frameworks
    Replies: 4
    Last Post: March 27th, 2009, 06:17 AM