Geek asks and answers

Wwv_flow.debug () vs apex_debug.message ()

I wrote a custom pl sql function for authorization. I know that my function is called by Apex authorization. But I need to debug what happens inside my authz function.

I successfully used wwv_flow.debug () before debugging the ajax calls that I made to store procs. I could see my messages in the apex debug window.

But when debugging my authorization function, I cannot see my debugging messages. I am trying to use wwv_flow.debug () and apex_debug.message ()

This leads me to two questions:

  • What is the difference between wwv_flow.debug () and apex_debug.message ()? When should everyone be used?

  • Any ideas on why my debug messages are not showing when my authorization function is called?

Thank.

UPDATE: it turns out that my messages did not appear because authorization was cached and my pl / sql code was not called, so I solved issue # 2. And I see both my wwv_flow.debug () and apex_debug.messages (). Question number 1 is still standing.

+5
source share
1 answer

wwv_flow.debug is an older version supported for backward compatibility.

apex_debug.message is a more modern version and supports wildcards, for example.

apex_debug.message('the value of %s + %s equals %s', 3, 5, 'eight');

This example is from APEX 4.2 docs

+5
source

More articles:


All Articles