Embedded SQL provides several advantages over a call-level interface:
Embedded SQL is easy to use because it is simply Transact-SQL with some added features that facilitate using it in an application.
It is an ANSI/ISO-standard programming language.
It requires less coding to achieve the same results as a call-level approach.
Embedded SQL is essentially identical across different host languages. Programming conventions and syntax change very little. Therefore, to write applications in different languages, you need not learn new syntax.
The precompiler can optimize execution time by generating stored procedures for the Embedded SQL statements.
