Programming Guide : Working with a Database : How You Can Access a Database with Standard SQL Statements : How You Can Use Database Procedures
 
Share this page          
How You Can Use Database Procedures
OpenROAD scripts can call database procedures, which are collections of statements managed as a single unit by the Ingres DBMS. Using database procedures provides another way for OpenROAD scripts to access the database.
For more information about calling a database procedure, see Programming Frames.
Creating a database procedure within an OpenROAD application requires using the execute immediate statement.
For more information about using the execute immediate statement, see How You Can Use the Execute Immediate Statement and the Language Reference Guide.