Functions: Debug Mode

Description: To examine a function in debug mode.

CREATE OR REPLACE FUNCTION test1 (inparm IN NUMBER)
RETURN NUMBER IS
BEGIN
  RETURN inparm;
END test1;
/
 
DESC user_plsql_object_settings
 
SELECT name, TYPE, plsql_debug
FROM user_plsql_object_settings;
 
ALTER FUNCTION test1 COMPILE DEBUG;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.