EMBEDDING DATABASE PROCEDURES IN DATA-DRIVEN APPLICATIONS

摘要

Disclosed herein are systems and methods for embedding database procedures in data-driven software applications written in a language different from the database-procedure language. For example, in some embodiments, the hosting application may be written in ABAP whereas the database procedure may be written in SQLScript. In various embodiments, the database procedures are encapsulated in specially marked methods of the host application, which, when called at runtime, cause the database procedures to be created in a database catalog and executed on a database server.

主权项

1. A method for embedding database procedures in a host application, the method comprising:
defining a host application using an application programming language, the host application including at least one class method declared, in the application programming language, as a database procedure; for each of the at least one class method declared as a database procedure, defining the database procedure in a body of the class method using a database-procedure language; and executing the host application on an application server communicatively coupled to a database server, whereby, upon a call of one of the at least one class method, the database procedure defined in that class method is created and executed on the database server.