Calling stored procedure from JSP Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Calling stored procedure from JSP

  1. #1
    Join Date
    Jan 2006

    Calling stored procedure from JSP

    Hi all

    I have a stored procedure, which when called from SQL*Plus finishes the processing in a few minutes.
    But the same procedure, when called from the front end (Java Server Page) does not complete even after an hour.
    The database is Oracle 9i running on Solaris.
    There is a bulk collect in the procedure.
    I have a feeling that this issue could be something specific to Oracle 9i on Solaris.
    Is there anything I should be checking for?
    I will be grateful for any suggestions from the forum members for solving this issue.

    Thanks in advance
    P.S: I am a newbie to this forum and this is my first post.

  2. #2
    Join Date
    Sep 2002
    trace the session, see what is going on

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width