We are playing with ORM+Oracle, and have several issues.
1. After any update of Model (with Database-first approach), we have to
manually restore oracle package name in full proc's name,
FOR EACH PACKAGED SUBPROGRAM. Full name does not persist ;-)
2. It seems, that ORM calls procedures (more exactly, packaged ones),
arguments in incorrect order.
In designer, we are observing arguments in alphabetical order,
in c# code Intellisense shows that arguments should follow in
reverse order (compared to Designer), whereas in DB the order
is totally different.
The error from Oracle:
wrong number or types of arguments in call to 'proc_name'
It makes me think, that internally ORM apply arguments in some
order, different from the correct one,
and, additionally, the syntax is being used: