All Oracle Error CodesOracle DBA Forum

ORA-06565:

cannot execute string from within stored procedure
Cause: 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.
Action: Remove the procedure from the calling stored procedure.