Stored Procedure Execution Time
Posted: Wed 24 Aug 2016 20:28
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?
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?