Call of stored procedure prepares statement

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 1
Joined: Thu 21 Jul 2011 10:29

Call of stored procedure prepares statement

Post by greulacs » Thu 21 Jul 2011 11:38

currently we are using entity framework to access an oracle database. Additionally we call stored procedures with the ExecuteFunction of the ObjectContext.

Code: Select all

public int ExecuteFunction(string functionName, params ObjectParameter[] parameters);
In the dbMonitor I can see that every call of a stored procedure is prepared. This causes an additional overhead in the database (calls sys.dbms_describe.describe_procedure) that leads in our case to a massive performance issue.

It wouldn’t be necessary to prepare the statement before every call. Is there an option to avoid the preparation? Maybe there is an option in the connection like “Unprepared Execution” in PostgreSQL?


Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 22 Jul 2011 10:12

We will investigate the possibility to avoid the preparation and notify you about the results as soon as possible.

Post Reply