Use stored procedures

Stored procedures extend the SQL capabilities of a database by adding control through Java program constructs that enforce business rules and perform administrative tasks.

Stored procedures can take advantage of the power of Java programming features. Stored procedures can:

• Receive and return input and output parameters
• Handle exceptions
• Include any number and kind of SQL statements to access the database
• Return a procedure result set to the calling application
• Make calls to other procedures
• Use predefined and external Java classes

OpenEdge SQL supports SQL statements in Java through several classes. See OpenEdge SQL Reference for more information.

The following table summarizes the functionality of these OpenEdge SQL supplied classes.

SQLIStatement

SQLPStatement

SQLCursor

DhSQLResultSet

DhSQLException