{"id":216,"date":"2013-10-02T11:26:11","date_gmt":"2013-10-02T15:26:11","guid":{"rendered":"http:\/\/dbtricks.com\/?p=216"},"modified":"2016-03-01T03:11:23","modified_gmt":"2016-03-01T07:11:23","slug":"oci-21700-object-does-not-exist-or-is-marked-for-delete-a-quick-reminder","status":"publish","type":"post","link":"https:\/\/dbtricks.com\/?p=216","title":{"rendered":"OCI-21700: object does not exist or is marked for delete (a quick reminder)"},"content":{"rendered":"<p>While many reasons can cause the <strong>OCI-21700: object does not exist or is marked for delete<\/strong> message, many times the OCI-21700 is caused by difficulty to access resources that are checked only at runtime. <\/p>\n<p>The most common reason for this error is granting execute privileges on a function without granting privileges on referenced object like types for example. <\/p>\n<p>Giving the same grants to the referenced objects will solve the problem.<\/p>\n<p><strong>Update:<\/strong> it appears that this error message can be raised when using Weblogic Data Source to run a function as well.<br \/>\nSometimes, mostly after a network failure\/database restart\/DB schema changes, the &#8220;OCI-21700: object does not exist or is marked for delete&#8221; will be raised. The weird thing is that the same function will fail when running it with Weblogic but it can run without a problem when you run it from the sql console using the same credentials.<br \/>\nIt appears that some Data Base actions like importing or droping objects or even unexpected network failure can &#8220;corrupt the DataSource&#8221;. If this is the case, all you have to do to solve the problem is <strong>restarting the Data Source<\/strong>.<\/p>\n<p><strong>Update 2:<\/strong>  Apparently, there is a bug in Oracle 10 that raises the OCI-21700 error regardless of providing the required permission. A unexplained workaround, if all else fails, is <strong>creating the function with the same name in the schema you are connected to and retry<\/strong>. Even weirder, if this solves the problem, it will still work even if you drop the newly created function. Sound like Oracle voodoo but hey, if it solve the problem &#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While many reasons can cause the OCI-21700: object does not exist or is marked for delete message, many times the OCI-21700 is caused by difficulty to access resources that are checked only at runtime. The most common reason for this error is granting execute privileges on a function without granting privileges on referenced object like [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[77],"class_list":["post-216","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oci-21700"],"_links":{"self":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=216"}],"version-history":[{"count":11,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/216\/revisions"}],"predecessor-version":[{"id":322,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/216\/revisions\/322"}],"wp:attachment":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}