I'm getting back a generic error msg - I will contact the DBA team about the exact error. As this may take some time if anyone knows whether executing SQL dynamically changes the way permissions should be applied (i.e. that the privs to the package are not enough for the objects referenced in the dynamic SQL to be recognisable) I would be very grateful.