dbms_metadata.get_ddl does not work when used in UTL_GENERATE_ORADEW about oradew-vscode HOT 3 CLOSED

I solved the problem adding AUTHID CURRENT_USER:
CREATE OR REPLACE PACKAGE UTL_GENERATE_ORADEW AUTHID CURRENT_USER

from oradew-vscode.

I am using the package proposed in oradew-generators:
UTL_GENERATE.sql
This returns me error:

 if l_object_type in ('VIEW', 'TRIGGER', 'TABLE') then         
      /*for rec in (
        select text
        from all_views
        where
          view_name = l_name
          and owner = schema    
      )loop    
        l_clob := rec.text;
       end loop;  */
       
       -- too hard !! for now as these object has different headers
       l_clob := dbms_metadata.get_ddl(l_object_type, name, schema);

from oradew-vscode.

Hey @Danieleeee ,

I am not sure where the problem is therefore I kindly invite you to contribute. you can open a PR I will gladly review it and provide with assistance in case you will need some help.

If there is a problem with UTL_GENERATE.sql please open a PR in oradew-generators repository. Thanks.

from oradew-vscode.