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