Stored Procedure Execution Time

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
wjm4
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Stored Procedure Execution Time

Post by wjm4 » 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?

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Stored Procedure Execution Time

Post by alexa » Thu 25 Aug 2016 07:45

Could you please provide us the CREATE definition of the stored procedure?

You can reply straight to our support system at supportATdevartDOTcom

Post Reply