The present invention relates to systems and methods to generate stored
procedure calling code. The invention includes system and methods that
utilize annotation(s) included in a stored procedure. The annotations
comprise attributes that indicate the intent to have stored procedure
calling code generated. After the annotated stored procedure becomes
available, the code is compiled and, optionally, checked for errors, and
an intermediate definition with metadata is created. The definition is a
stored procedure interface language (SPIL) file. The SPIL definition is
then utilized to generate high-level, stored procedure calling code, or
class libraries. The high level code can then be employed within an
application to invoke the stored procedure.