Functions: Recompile

Description: Recompile a function without recreating it.

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

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.