If you try to declare a SQL macro in a package and make use of it in another function / procedure in the package, you’ll get an error.ORA-62565: The SQL Macro method failed with error(s). ORA-04067: not executed, package body <package body name> does not existWhy and how can you fix it? Example: To show … Continue reading ORA-62565 When Compiling Package Which Both Declares and Calls SQL Macro.
