Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006

    Unanswered: Select Query works fine in SQL prompt but takes time in Stored Procedure

    hi ,

    i am writing a Stored Procedure which return ref cursor to the calling application.

    The select query works fine in the sql prompt and takes only 200 millisec. the same query is used in the ref cursor.

    after execution of the stored procedure, the print time for the ref cursor is 5 min.

    could you plz suggest some ways so that i could improve the performance.

    thanks in advance,

    Thrishankar M

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1
    Show us some code, we aren't psychic!

Posting Permissions

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