However, there are differences between the various database servers in how they handle stored procedure calls ... can be called from standard SQL. This allows you to encapsulate complex application ...

You can use full, inline SQL statements in the prepared statement function or send the database a stored procedure function. A stored procedure is a program that is stored on the database server.