Well, not really sure what your problem is. But when I was working with the Oracle Adapter in the past it hard codes the DSN name and procedure names in the auto generated schema.
So, as a starter you might want to try to regenerate your schema if you think those setting might be wrong.
In the past, when I saw that type of error is was because the schema was wrong.
Hope this helps.