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
Writing Scripts and Procedures (see
Writing Scripts and Procedures).
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 (see
How You Can Use the Execute Immediate Statement) and the
Language Reference Guide.