Oracle Error Message
ORA-06565: cannot execute string from within stored procedure
Reason for the Error
The named procedure cannot be executed from within a stored procedure, function or package. This function can only be used from pl/sql anonymous blocks.
Solution
Remove the procedure from the calling stored procedure.