US Patent 7260569 Evaluating expressions in stored procedures

A database system includes components for executing stored procedures that include at least one of a conditional expression, assignment expression, and dynamic database query language (e.g., SQL) statement. For each such expression, a predetermined type of code is generated and inserted into the object code corresponding to the stored procedure. When executing the stored procedure object code, the predetermined type of code is evaluated directly without having to generate a separate database query language statement.