title: What is the stored procedures performance compared to embedded SQL in various RDBMs?
body: <p>From my experience with DB2 on Z/OS there is no difference between embedded SQL and stored procedures as both get compiled to native code. On the other hand I know that in Oracle there is a huge difference - is it true and how is it in other DBs? Please provide some links to support your claims.</p>