5. 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 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.