{"id":14355,"date":"2020-02-21T12:12:45","date_gmt":"2020-02-21T20:12:45","guid":{"rendered":"http:\/\/clartechsolutions.com\/?p=14355"},"modified":"2023-03-04T20:56:31","modified_gmt":"2023-03-04T20:56:31","slug":"niveles-de-depuracion-apex","status":"publish","type":"post","link":"https:\/\/kiusi.com\/en\/niveles-de-depuracion-apex\/","title":{"rendered":"Niveles de depuraci\u00f3n APEX"},"content":{"rendered":"<p>En APEX tenemos diferentes niveles de mensajes de depuraci\u00f3n, ahora lo estoy usando much\u00edsimo para depurar los reportes que estoy trabajando con el plugin de APEX Office Print y poder ver los mensajes de AOP \ud83d\ude42<\/p>\n<p>Como sabemos en la sintaxis de la URL de APEX podemos activar o desactivar la depuraci\u00f3n en el quinto argumento:<\/p>\n<p>Por ejemplo:<\/p>\n<pre class=\"oac_no_warn\" dir=\"ltr\">f?p=App:Page:Session:Request:<strong>Debug<\/strong>:ClearCache:itemNames:itemValues:PrinterFriendly\n<\/pre>\n<p>El argumento <strong>Debug<\/strong>: muestra los detalles de procesamiento de la aplicaci\u00f3n. Los valores v\u00e1lidos para este indicador incluyen:<\/p>\n<ul>\n<li>YES<\/li>\n<li>LEVELn<\/li>\n<li>NO<\/li>\n<\/ul>\n<p>Al establecer este indicador en YES, se muestran detalles sobre el procesamiento de la aplicaci\u00f3n. Ahora si establecemos este indicador en LEVELn (donde n est\u00e1 entre 1 y 9) controla el nivel de detalle de depuraci\u00f3n que se muestra. El valor de YES es igual a LEVEL4.<\/p>\n<p>Podemos hacer referencia al indicador de depuraci\u00f3n utilizando la siguiente sintaxis:<\/p>\n<ul>\n<li>Cadena de sustituci\u00f3n corta: <strong>&amp;DEBUG.<\/strong><\/li>\n<li>PL\/SQL: <strong>V(&#8216;DEBUG&#8217;)<\/strong><\/li>\n<li>Variable Bind: <strong>:DEBUG<\/strong><\/li>\n<\/ul>\n<p>El paquete <strong>APEX_DEBUG<\/strong> proporciona funciones de utilidad para administrar el registro de mensajes de depuraci\u00f3n. Espec\u00edficamente, este paquete nos proporciona las API necesarias para instrumentar y depurar el c\u00f3digo PL\/SQL contenido en nuestra aplicaci\u00f3n APEX, as\u00ed como el c\u00f3digo PL\/SQL en los procedimientos y funciones almacenados en la base de datos.<\/p>\n<p>Si echamos un vistazo a la especificaci\u00f3n del paquete, podemos ver el significado de cada nivel (aunque faltan los niveles 3 y 7).<\/p>\n<p>Constantes usadas en el pkg:<\/p>\n<pre>subtype t_log_level is pls_integer; \nc_log_level_error constant t_log_level := 1; -- critical error \nc_log_level_warn constant t_log_level := 2; -- less critical error \nc_log_level_info constant t_log_level := 4; -- default level if debugging is enabled (for example, used by apex_application.debug) \nc_log_level_app_enter constant t_log_level := 5; -- application: messages when procedures\/functions are entered \nc_log_level_app_trace constant t_log_level := 6; -- application: other messages within procedures\/functions \nc_log_level_engine_enter constant t_log_level := 8; -- Application Express engine: messages when procedures\/functions are entered \nc_log_level_engine_trace constant t_log_level := 9; -- Application Express engine: other messages within procedures\/functions<\/pre>\n<p>Podemos establecer este nivel al agregar mensajes de depuraci\u00f3n manualmente mediante el procedimiento apex_debug.message.<\/p>","protected":false},"excerpt":{"rendered":"<p>En APEX tenemos diferentes niveles de mensajes de depuraci\u00f3n, ahora lo estoy usando much\u00edsimo para depurar los reportes que estoy trabajando con el plugin de APEX Office Print y poder ver los mensajes de AOP \ud83d\ude42 Como sabemos en la sintaxis de la URL de APEX podemos activar o desactivar la depuraci\u00f3n en el quinto<a class=\"more-link\" href=\"https:\/\/kiusi.com\/en\/niveles-de-depuracion-apex\/\">Continue reading <span class=\"screen-reader-text\">&#8220;Niveles de depuraci\u00f3n APEX&#8221;<\/span><\/a><\/p>","protected":false},"author":132749711,"featured_media":16670,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":true},"categories":[121913,121923,121928,121933,121999,121930,122037],"tags":[121903,122021,122031,122032,122033,122034,121886],"class_list":["post-14355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-oracle-apex-18-1","category-oracle-apex-18-2","category-oracle-apex-19-1","category-oracle-apex-19-2","category-oracle-apex-5-0","category-oracle-apex-5-1","tag-apex","tag-aplicaciones","tag-debug","tag-depuracion","tag-errores","tag-level","tag-oracle","entry"],"jetpack_publicize_connections":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paMvMS-3Jx","amp_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/02\/12-Niveles-de-depuracion-APEX.jpg?fit=2952%2C1737&ssl=1","_links":{"self":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/14355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/users\/132749711"}],"replies":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/comments?post=14355"}],"version-history":[{"count":1,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/14355\/revisions"}],"predecessor-version":[{"id":15888,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/14355\/revisions\/15888"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media\/16670"}],"wp:attachment":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media?parent=14355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/categories?post=14355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/tags?post=14355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}