DBMS_METADAT.PUT
A reader, March 26, 2019 - 4:26 pm UTC
Hi Chris,
Thanks for your reply.
I have create an objects using dbms_metadata.put succesfully..
However when i executed dbms_metadata.put in parallel chunks using dbms_parallel_execute, it always gets rejected saying insufficient privileges for DBMS_SQL (user hase direct execute grants on DBMS_SQL).
Strangely, when i run the same dbms_metadata.put in SQL developer single session it gets created successfully..
is there any restriction of executing .put in jobs?
March 28, 2019 - 11:36 am UTC
What exactly are you doing? Show us your code!