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

Thread: Calling stored procedure from JSP

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    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
    Vadi
    P.S: I am a newbie to this forum and this is my first post.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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