Progress
Database Design
Guide


Java Stored Procedures

A Java stored procedure is a group of SQL-92 statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server.

Stored procedures can be compiled and executed with different parameters and results. They may have any combination of input, output and input/output parameters. Stored procedures do not have to be tied to database events.

Java stored procedures cannot be called from Progress 4GL clients.


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