select DBMS_METADATA.GET_DDL('FGA_POLICY','CODE_SED_TRANS_TEMP_POL_00') ddl_str from dual;


ORA-31600: invalid input value CODE_SED_TRANS_TEMP_POL_00 for parameter NAME in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 6751
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6628
ORA-06512: at "SYS.DBMS_METADATA", line 9774
ORA-06512: at line 1
31600. 00000 -  "invalid input value %s for parameter %s in function %s"
*Cause:    A NULL or invalid value was supplied for the parameter.
*Action:   Correct the input value and try the call again.

select dbms_metadata.get_dependent_ddl('RLS_POLICY','<Table Name>,'<Table Owner>') from dual;

SCOTT@orcl_12.1.0.2.0> select text
  2  from   dba_source
  3  where  (owner, name) in
  4  	    (select pfschma, ppname
  5  	     from   sys.fga$
  6  	     where  pname = 'DEPT_ACCESS_HANDLED')
  7  order  by type, line
  8  /

TEXT
--------------------------------------------------------------------------------
PACKAGE audit_handler
AS
  PROCEDURE handle_tab_access
    ( object_schema  IN VARCHAR2
    , object_name    IN VARCHAR2
    , policy_name    IN VARCHAR2
    );
END audit_handler;
PACKAGE BODY audit_handler
AS
  PROCEDURE handle_tab_access
    ( object_schema  IN VARCHAR2
    , object_name    IN VARCHAR2
    , policy_name    IN VARCHAR2
    )
  AS
    PRAGMA AUTONOMOUS_TRANSACTION;
  BEGIN
      INSERT INTO user_query_audit
        ( username, when, query)
      VALUES
        ( USER, SYSTIMESTAMP, SYS_CONTEXT ('USERENV', 'CURRENT_SQL'));
      COMMIT;
  END handle_tab_access;
END audit_handler;

25 rows selected.

SCOTT@orcl_12.1.0.2.0> select dbms_metadata.get_dependent_ddl
  2  	      ('FGA_POLICY', 'DEPT', 'SCOTT')
  3  from   dual
  4  /

DBMS_METADATA.GET_DEPENDENT_DDL('FGA_POLICY','DEPT','SCOTT')
--------------------------------------------------------------------------------

  BEGIN DBMS_FGA.ADD_POLICY('SCOTT','DEPT','DEPT_ACCESS_HANDLED','','','SCOTT','
AUDIT_HANDLER.HANDLE_TAB_ACCESS',TRUE,'SELECT',DBMS_FGA.DB_EXTENDED,DBMS_FGA.ANY
_COLUMNS,NULL); END;


1 row selected.