set errorlogging on truncate
sho errors procedure my_proc
putting "/" like that is a really really bad idea..... that belongs in mysql2.sql
the create procedure "succeeded", it was not an error. there was no ORA-xxxxx raised. that is why you don't see an error, it wasn't one.