Call of stored procedure prepares statement
Posted: Thu 21 Jul 2011 11:38
Hello,
currently we are using entity framework to access an oracle database. Additionally we call stored procedures with the ExecuteFunction of the ObjectContext.
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?
Thanks
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);
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?
Thanks