I have a stored procedure that returns a ref_cursor as an out parameter. When I run this stored procedure from dbforge for oracle by right clicking on the procedure and selecting execute. I get a high response time.
When I run this stored procedure from a query using the below code, I get a fast response time.
BEGIN
SP1(LPN,P_REF_CUR);
END;
Why the difference in response time?
Stored Procedure Execution Time
Re: Stored Procedure Execution Time
Could you please provide us the CREATE definition of the stored procedure?
You can reply straight to our support system at supportATdevartDOTcom
You can reply straight to our support system at supportATdevartDOTcom