Progress
SQL-92
Guide and Reference


Using Stored Procedures

This section describes basic stored procedure operations such as creating and deleting, and provides a tutorial on using Progress SQL-92-supplied classes. See "Java Class Reference" for detailed reference information on the classes and their methods.

Stored procedures extend the SQL capabilities of a database by adding control flow 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:

Progress SQL-92 provides support for SQL statements in Java through several classes. See "Java Class Reference" for detailed reference information.

Table 5–1 summarizes the functionality of these Progress SQL-92-supplied classes.

Table 5–1: Summary of Progress SQL-92 Java Classes 
Functionality
Progress SQL-92 Java Class
Immediate (one-time) execution of SQL statements
SQLIStatement
Prepared (repeated) execution of SQL statements
SQLPStatement
Retrieval of SQLPrepared (repeated) execution of SQL statements result sets
SQLCursor
Returning a procedure result set to the application
DhSQLResultSet
Exception handling for SQL statements
DhSQLException


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095