Method and apparatus for invoking a stored procedure or a user defined interpreted language function in a database management system

A computer program product comprising:

• a computer usable medium having computer readable program code means embodied therein for invoking a stored procedure or user defined function in a database management system capable of operating on a data processing system said computer readable program code means in said computer program product comprising:
• computer readable program code means for causing a computer to effect a database server associated with invocation means adapted to receive a request for invocation of a stored procedure or user defined function in a specified interpreted language;
• said invocation means being adapted to:
• load an interpreter for said specified language if said server is not already loaded, and setup an interprocess communication between said interpreter and said database server;
• said invocation means being adapted to return an error message to an application calling for invocation of said stored procedure or user defined function, without otherwise impeding operation of said database server;
• and
• wherein said invocation means is adapted to load a stored procedure library as if it were a library in a default programming language and run said stored procedure if it were found in said library, and otherwise read the stored procedure system catalogue of the database management system to determine the language of said stored procedure, and load the appropriate interpreter for the specified interpreted language of the stored procedure if said interpreter was not already loaded;
• and if said interpreter fails to load properly, returning a predefined error code to the application calling for said stored procedure;
• and when said interpreter is loaded, setup interprocess communication between said interpreter and said database server.

A method for invoking a stored procedure or user defined function in a database management system capable of operating on a data processing system comprising:

• associating a database server with invocation means adapted to receive a request for invocation of a stored procedure or user defined function in a specified interpreted language;
• said invocation means being adapted to:
• load an interpreter for said specified language if said server is not already loaded, and setup an interprocess communication between said interpreter and said database server;
• said invocation means being adapted to return an error message to an application calling for invocation of said stored procedure or user defined function, without otherwise impeding operation of said database server;
• and
• wherein said invocation means is adapted to load a stored procedure library as if it were a library in a default programming language and run said stored procedure if it were found in said library, and otherwise read the stored procedure system catalogue of the database management system to determine the language of said stored procedure, and load the appropriate interpreter for the specified interpreted language of the stored procedure if said interpreter was not already loaded;
• and if said interpreter fails to load properly, returning a predefined error code to the application calling for said stored procedure;
• and when said interpreter is loaded, setup interprocess communication between said interpreter and said database server.