Devart Forums

Does the Context object query Oracle when instantiated?

And if so, what is it querying for?

I'm getting this error when we are moving to staging environment but I can't pinpoint why/what it's asking oracle for, some kind of meta-data or something?

-Joe

This may occur if the model contains pipelined Oracle functions; the query is performed to get the detailed metadata of these functions. Please confirm that this is the case (i.e., that your model has methods representing pipelined functions).

We are working on this issue, but cannot provide any timeframe at the moment. We will post here when any new information is available.

I removed all the elements and added only those that were in our staging environment and now it works. It is entirely possible that the original model had pipelined functions.

Curious why you need the metadata during this time instead of at compile time?

-Joe

Oracle stored procedures that return result sets may have a cursor parameter with the type not described in the model. To treat this case, the LinqConnect runtime checks such functions when the data context metadata is prepared.

We will analyze the possibility of changing this behaviour, and post about the results here.