var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select Query works fine in SQL prompt but takes time in Stored Procedure
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,
Show us some code, we aren't psychic!