Call of stored procedure prepares statement

[greulacs]

Hello,
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?

Thanks

[Shalex]

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