Stored Procedure Execution Time

Stored Procedure Execution Time

Postby 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?
wjm4
 
Posts: 72
Joined: Mon 12 Feb 2007 21:31

Re: Stored Procedure Execution Time

Postby 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
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle