How to get a stored stored procedure to work when a duplicate inline procedure works
I am having an issue using dbms_metadata.get_dependent_ddl to work within a stored procedure. When I execute it as an inline procedure it works fine. What is the difference in the way they execute?
Here is a snippet of what I am trying to do, in the end this will go into a package and other tasks will be performed. But this is the failure point right now.
inline procedure
declare
index_script clob;
sql_stmt varchar2(100);
begin
select dbms_metadata.get_dependent_ddl('INDEX', 'ACCOUNT','MART1') into index_script from dual;
DBMS_OUTPUT.PUT_LINE(index_script);
Here is a snippet of what I am trying to do, in the end this will go into a package and other tasks will be performed. But this is the failure point right now.
inline procedure
declare
index_script clob;
sql_stmt varchar2(100);
begin
select dbms_metadata.get_dependent_ddl('INDEX', 'ACCOUNT','MART1') into index_script from dual;
DBMS_OUTPUT.PUT_LINE(index_script);
0