{"id":18318,"date":"2026-02-27T14:22:23","date_gmt":"2026-02-27T13:22:23","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=18318"},"modified":"2026-02-27T14:22:38","modified_gmt":"2026-02-27T13:22:38","slug":"oracle-pls-00707","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2026\/02\/27\/oracle-pls-00707\/","title":{"rendered":"Oracle PLS-00707 unsupported construct or internal error"},"content":{"rendered":"\n<p>This error occurs sometimes :<\/p>\n\n\n\n<p>When I try to execute the following PL-SQL code I have right results:<\/p>\n\n\n\n<p>PLS-00707: unsupported construct or internal error [2603]<\/p>\n\n\n\n<p>It seems to be caused by the\u00a0 parameter PL\/SCOPE variable when it uses the value &#8220;IDENTIFIERS:ALL&#8221;.<\/p>\n\n\n\n<p><br>SQL Developer during connection establishing changes the session parameter PLSCOPE_SETTINGS from IDENTIFIERS:NONE (default) to IDENTIFIERS:ALL.<br>Same error was received in SQL PLUS when issuing an &#8220;alter session set PLSCOPE_SETTINGS=IDENTIFIERS:ALL&#8221;.<\/p>\n\n\n\n<p>More about PL\/Scope can be found here:<br><a href=\"http:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28424\/adfns_plscope.htm\">http:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28424\/adfns_plscope.htm<\/a><br><a href=\"http:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/initparams178.htm\">http:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/initparams178.htm<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This error occurs sometimes : When I try to execute the following PL-SQL code I have right results: PLS-00707: unsupported construct or internal error [2603] It seems to be caused by the\u00a0 parameter PL\/SCOPE variable when it uses the value &#8220;IDENTIFIERS:ALL&#8221;. SQL Developer during connection establishing changes the session parameter PLSCOPE_SETTINGS from IDENTIFIERS:NONE (default) to&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2026\/02\/27\/oracle-pls-00707\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Oracle PLS-00707 unsupported construct or internal error<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":18319,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[884,1047],"tags":[],"class_list":["post-18318","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-oracle-it-vendors"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/18318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=18318"}],"version-history":[{"count":2,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/18318\/revisions"}],"predecessor-version":[{"id":18321,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/18318\/revisions\/18321"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media\/18319"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=18318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=18318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=18318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}