Greetings,
I am trying to get DDL of a table in a remote database using DB link. I have used the following statement, but I am getting a PLS-564 error saying lob arguments are not permitted. What am I doing wrong?
SELECT DBMS_METADATA.GET_DDL@prod_db_link('TABLE', 'TABLE_NAME', 'OWNER') AS DDL
FROM DUAL;