Developing Portable Applications : 4. Gateway Database Procedures : How to Create Stored Database Procedures from Ingres Clients
 
Share this page                  
How to Create Stored Database Procedures from Ingres Clients
The stored procedures must be created before the gateway can access them as gateway database procedures. Non-OpenSQL syntax is needed to create these stored procedures. It is possible to have an Ingres client create a stored procedure by using the OpenSQL DIRECT EXECUTE IMMEDIATE statement. See the chapter "Achieving Transparency and Portability" for information on the DIRECT EXECUTE IMMEDIATE statement. The user should have the native DBMS create procedure permission.
After the stored procedure has been created, it can be registered and executed by an Ingres client application.