ORA-04043: object XXXXXX does not exist

ORA-04043: object XXXXXX does not exist

Postby jlentrichia » Thu 28 Jul 2011 11:42

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
jlentrichia
 
Posts: 12
Joined: Wed 11 May 2011 15:12

Postby StanislavK » Thu 28 Jul 2011 15:29

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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby jlentrichia » Thu 28 Jul 2011 16:58

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
jlentrichia
 
Posts: 12
Joined: Wed 11 May 2011 15:12

Postby StanislavK » Fri 29 Jul 2011 11:02

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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle