{"id":395,"date":"2024-05-25T11:15:15","date_gmt":"2024-05-25T14:15:15","guid":{"rendered":"https:\/\/www.isacaguiar.com.br\/blog\/?p=395"},"modified":"2024-06-05T18:40:04","modified_gmt":"2024-06-05T21:40:04","slug":"ora-06508-pl-sql-could-not-find-program-unit-being-called","status":"publish","type":"post","link":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/","title":{"rendered":"ORA-06508: PL\/SQL: could not find program unit being called"},"content":{"rendered":"<p>O erro <code>ORA-06508: PL\/SQL: could not find program unit being called<\/code> ocorre quando uma unidade de programa PL\/SQL (como um procedimento, fun\u00e7\u00e3o, pacote ou tipo de objeto) que est\u00e1 sendo chamada n\u00e3o pode ser encontrada ou est\u00e1 em um estado inv\u00e1lido. Esse erro pode ocorrer por v\u00e1rias raz\u00f5es:<\/p>\n<ol>\n<li><strong>Objeto N\u00e3o Encontrado<\/strong>: O objeto chamado n\u00e3o existe ou foi removido.<\/li>\n<li><strong>Estado Inv\u00e1lido<\/strong>: O objeto est\u00e1 em um estado inv\u00e1lido, talvez porque depende de outro objeto que foi modificado ou removido.<\/li>\n<li><strong>Problemas de Compila\u00e7\u00e3o<\/strong>: O objeto n\u00e3o foi compilado corretamente.<\/li>\n<\/ol>\n<h2>Passos para Diagnosticar e Corrigir o Problema<\/h2>\n<h3><strong>1. Verificar o Estado do Objeto<\/strong><\/h3>\n<p><span style=\"font-size: 1.125rem;\">Use a seguinte consulta para verificar se o objeto chamado est\u00e1 em um estado inv\u00e1lido:<br \/>\n<\/span><span style=\"font-size: 1.125rem;\"><span style=\"font-size: 1.125rem;\">Se voc\u00ea encontrar o objeto na lista, ser\u00e1 necess\u00e1rio recompil\u00e1-lo.<\/span><\/span><\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">SELECT object_name, object_type, status\r\nFROM dba_objects\r\nWHERE status = 'INVALID';<\/code><\/pre>\n<\/div>\n<h3><strong>2. Recompilar Objetos Inv\u00e1lidos<\/strong><\/h3>\n<p>Se o objeto est\u00e1 inv\u00e1lido, voc\u00ea pode tentar recompil\u00e1-lo usando o comando <code>ALTER<\/code>:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">ALTER PACKAGE package_name COMPILE;\r\n<\/code><\/pre>\n<\/div>\n<p>Ou, para recompilar todas as depend\u00eancias:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">ALTER PACKAGE package_name COMPILE BODY;\r\n<\/code><\/pre>\n<\/div>\n<p>Para recompilar todos os objetos inv\u00e1lidos no esquema:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">BEGIN\r\n    DBMS_UTILITY.compile_schema(schema =&gt; 'NOME_DO_ESQUEMA');\r\nEND;\r\n<\/code><\/pre>\n<\/div>\n<p>Substitua &#8216;NOME_DO_ESQUEMA&#8217; pelo nome do esquema apropriado.<\/p>\n<h3><strong>3. Verificar Depend\u00eancias<\/strong><\/h3>\n<p>Se o objeto depende de outros objetos que foram modificados ou removidos, voc\u00ea pode usar a seguinte consulta para verificar as depend\u00eancias:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">SELECT *\r\nFROM dba_dependencies\r\nWHERE referenced_name = 'NOME_DO_OBJETO'\r\nAND referenced_type = 'PACKAGE'; -- ou FUNCTION, PROCEDURE, etc.\r\n<\/code><\/pre>\n<\/div>\n<h3><strong>4. Verificar o Caminho Completo e Privil\u00e9gios<\/strong><\/h3>\n<p>Certifique-se de que voc\u00ea est\u00e1 chamando o objeto com o caminho completo, incluindo o nome do esquema se necess\u00e1rio, e que voc\u00ea tem os privil\u00e9gios necess\u00e1rios para acessar o objeto.<\/p>\n<h2>Exemplo de Diagn\u00f3stico<\/h2>\n<p>Aqui est\u00e1 um exemplo pr\u00e1tico de como voc\u00ea pode diagnosticar e corrigir o erro:<\/p>\n<h3>1. Verificar Objetos Inv\u00e1lidos<\/h3>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">SELECT object_name, object_type, status\r\nFROM dba_objects\r\nWHERE status = 'INVALID';\r\n<\/code><\/pre>\n<\/div>\n<h3>2. Recompilar um Objeto Inv\u00e1lido<\/h3>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">ALTER PACKAGE my_package COMPILE;\r\n<\/code><\/pre>\n<\/div>\n<h3>3. Recompilar Depend\u00eancias<\/h3>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">ALTER PACKAGE my_package COMPILE BODY;\r\n<\/code><\/pre>\n<\/div>\n<h3>4. Recompilar Todo o Esquema<\/h3>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">BEGIN\r\n    DBMS_UTILITY.compile_schema(schema =&gt; 'MY_SCHEMA');\r\nEND;\r\n<\/code><\/pre>\n<\/div>\n<h2>Exemplo de Caso Espec\u00edfico<\/h2>\n<p>Se voc\u00ea tem um procedimento chamado MY_PROCEDURE em um pacote chamado MY_PACKAGE, e est\u00e1 recebendo o erro ao cham\u00e1-lo, fa\u00e7a o seguinte:<\/p>\n<h3>1. Verifique o estado do pacote:<\/h3>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">SELECT object_name, object_type, status\r\nFROM dba_objects\r\nWHERE object_name = 'MY_PACKAGE';<\/code><\/pre>\n<\/div>\n<h3>2. Recompile o pacote e seu corpo:<\/h3>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">ALTER PACKAGE MY_PACKAGE COMPILE;\r\nALTER PACKAGE MY_PACKAGE COMPILE BODY;<\/code><\/pre>\n<\/div>\n<h3>3. Recompile todo o esquema se necess\u00e1rio:<\/h3>\n<div class=\"hcb_wrap\">\n<pre class=\"wp-block-preformatted prism line-numbers lang-sql\" data-lang=\"SQL\"><code class=\"language-sql\">BEGIN\r\n    DBMS_UTILITY.compile_schema(schema =&gt; 'MY_SCHEMA');\r\nEND;\r\n<\/code><\/pre>\n<\/div>\n<p>Seguindo esses passos, voc\u00ea deve ser capaz de identificar e corrigir a causa do erro <strong>ORA-06508<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O erro ORA-06508: PL\/SQL: could not find program unit being called ocorre quando uma unidade de programa PL\/SQL (como um procedimento, fun\u00e7\u00e3o,\u2026<\/p>\n","protected":false},"author":1,"featured_media":427,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,17],"tags":[],"class_list":["post-395","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bd","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ORA-06508: PL\/SQL: could not find program unit being called - Blog do Aguiar<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-06508: PL\/SQL: could not find program unit being called - Blog do Aguiar\" \/>\n<meta property=\"og:description\" content=\"O erro ORA-06508: PL\/SQL: could not find program unit being called ocorre quando uma unidade de programa PL\/SQL (como um procedimento, fun\u00e7\u00e3o,\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog do Aguiar\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/isac.velozo.aguiar\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-25T14:15:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-05T21:40:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"isacaguiar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"isacaguiar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/\"},\"author\":{\"name\":\"isacaguiar\",\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/#\/schema\/person\/78719359439f068d8b1e5e0bcb9d934d\"},\"headline\":\"ORA-06508: PL\/SQL: could not find program unit being called\",\"datePublished\":\"2024-05-25T14:15:15+00:00\",\"dateModified\":\"2024-06-05T21:40:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/\"},\"wordCount\":350,\"image\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp\",\"articleSection\":[\"Banco de Dados\",\"Oracle\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/\",\"url\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/\",\"name\":\"ORA-06508: PL\/SQL: could not find program unit being called - Blog do Aguiar\",\"isPartOf\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp\",\"datePublished\":\"2024-05-25T14:15:15+00:00\",\"dateModified\":\"2024-06-05T21:40:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/#\/schema\/person\/78719359439f068d8b1e5e0bcb9d934d\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage\",\"url\":\"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp\",\"contentUrl\":\"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp\",\"width\":1024,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"http:\/\/www.isacaguiar.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-06508: PL\/SQL: could not find program unit being called\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/#website\",\"url\":\"https:\/\/www.isacaguiar.com.br\/blog\/\",\"name\":\"Blog do Aguiar\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.isacaguiar.com.br\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.isacaguiar.com.br\/blog\/#\/schema\/person\/78719359439f068d8b1e5e0bcb9d934d\",\"name\":\"isacaguiar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e22bb054d1154f07e6c91b82f0d68a219b6b04b58e5e3692c30cf457b51a9e9f?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e22bb054d1154f07e6c91b82f0d68a219b6b04b58e5e3692c30cf457b51a9e9f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e22bb054d1154f07e6c91b82f0d68a219b6b04b58e5e3692c30cf457b51a9e9f?s=96&d=mm&r=g\",\"caption\":\"isacaguiar\"},\"url\":\"https:\/\/www.isacaguiar.com.br\/blog\/author\/isacaguiar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-06508: PL\/SQL: could not find program unit being called - Blog do Aguiar","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/","og_locale":"pt_BR","og_type":"article","og_title":"ORA-06508: PL\/SQL: could not find program unit being called - Blog do Aguiar","og_description":"O erro ORA-06508: PL\/SQL: could not find program unit being called ocorre quando uma unidade de programa PL\/SQL (como um procedimento, fun\u00e7\u00e3o,\u2026","og_url":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/","og_site_name":"Blog do Aguiar","article_publisher":"https:\/\/www.facebook.com\/isac.velozo.aguiar","article_published_time":"2024-05-25T14:15:15+00:00","article_modified_time":"2024-06-05T21:40:04+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp","type":"image\/webp"}],"author":"isacaguiar","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"isacaguiar","Est. tempo de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#article","isPartOf":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/"},"author":{"name":"isacaguiar","@id":"https:\/\/www.isacaguiar.com.br\/blog\/#\/schema\/person\/78719359439f068d8b1e5e0bcb9d934d"},"headline":"ORA-06508: PL\/SQL: could not find program unit being called","datePublished":"2024-05-25T14:15:15+00:00","dateModified":"2024-06-05T21:40:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/"},"wordCount":350,"image":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp","articleSection":["Banco de Dados","Oracle"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/","url":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/","name":"ORA-06508: PL\/SQL: could not find program unit being called - Blog do Aguiar","isPartOf":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage"},"image":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp","datePublished":"2024-05-25T14:15:15+00:00","dateModified":"2024-06-05T21:40:04+00:00","author":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/#\/schema\/person\/78719359439f068d8b1e5e0bcb9d934d"},"breadcrumb":{"@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#primaryimage","url":"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp","contentUrl":"https:\/\/www.isacaguiar.com.br\/blog\/wp-content\/uploads\/2024\/05\/DALL\u00b7E-2024-05-30-17.25.58-A-professional-image-depicting-a-database-error-for-an-article-titled-ORA-06508_-PL_SQL_-could-not-find-program-unit-being-called.-The-image-feature.webp","width":1024,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/www.isacaguiar.com.br\/blog\/ora-06508-pl-sql-could-not-find-program-unit-being-called\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"http:\/\/www.isacaguiar.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"ORA-06508: PL\/SQL: could not find program unit being called"}]},{"@type":"WebSite","@id":"https:\/\/www.isacaguiar.com.br\/blog\/#website","url":"https:\/\/www.isacaguiar.com.br\/blog\/","name":"Blog do Aguiar","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.isacaguiar.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Person","@id":"https:\/\/www.isacaguiar.com.br\/blog\/#\/schema\/person\/78719359439f068d8b1e5e0bcb9d934d","name":"isacaguiar","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/e22bb054d1154f07e6c91b82f0d68a219b6b04b58e5e3692c30cf457b51a9e9f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e22bb054d1154f07e6c91b82f0d68a219b6b04b58e5e3692c30cf457b51a9e9f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e22bb054d1154f07e6c91b82f0d68a219b6b04b58e5e3692c30cf457b51a9e9f?s=96&d=mm&r=g","caption":"isacaguiar"},"url":"https:\/\/www.isacaguiar.com.br\/blog\/author\/isacaguiar\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/posts\/395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/comments?post=395"}],"version-history":[{"count":15,"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/posts\/395\/revisions"}],"predecessor-version":[{"id":666,"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/posts\/395\/revisions\/666"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/media\/427"}],"wp:attachment":[{"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/media?parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/categories?post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isacaguiar.com.br\/blog\/wp-json\/wp\/v2\/tags?post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}