Bonnie,
Thank you for your reply... I actually got it to work.
I am not exactly sure why this would cause an error but originally I was deleting parent and child records in one stored procedure. I separated those two delete statements by creating another stored procedure and now everything works...

Daniel