Progress
SQL-92
Guide and Reference


Creating Stored Procedures

The Java source text that makes up the body of a stored procedure is not a complete Java program, but a program fragment or snippet that the Progress SQL-92 server converts into a complete Java class when it processes a CREATE PROCEDURE statement. Creating a stored procedure involves the following general steps:

  1. A client application or tool (SQL Explorer, an ODBC application, or a JDBC application) issues a CREATE PROCEDURE statement that contains the Java source text.
  2. The Progress SQL-92 server adds code to the Java snippet to create a complete Java class and submits the combined code to the Java compiler.
  3. Presuming there are no Java compilation errors, the Java compiler returns compiled bytecode back to the Progress SQL-92 server. If there are compilation errors, the Progress SQL-92 server passes the first error message generated by the compiler back to the application or tool that issued the CREATE PROCEDURE statement.
  4. The Progress SQL-92 server stores both the Java source text and the bytecode form of the procedure in the database.

Figure 5–1 illustrates the general steps for creating a Java stored procedure.

Figure 5–1: Creating Stored Procedures


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