Use stored procedure to datapump

All,

We are using Oracle 12.2, I am testing this simple procedure that I got from Metalink to do a FULL datapump from a stored procedure, so I can use dbms_scheduler to schedule it.

I created the DPDUMP directory

I granted read/write on the directory to my account.

I granted execute on the sys.dbms_datapump to my account

I granted exp full database to my account

I granted datapump_exp_full_database to my account

I granted datapump_imp_full_database to my account

I can run this PROCEDURE successfully as an Anonymous Block, but when I try to create it as a STORED PROCEDURE it fails.