Progress
SQL-92
Guide and Reference
What Is a Java Snippet?
The core of the stored procedure is the java_snippet. The snippet contains a sequence of Java statements. When it processes a CREATE PROCEDURE statement, Progress SQL-92 adds header and footer “wrapper” code to the Java snippet. This wrapper code:
- Declares a class with the name username_procname_SP, where username is the user name of the database connection that issued the CREATE PROCEDURE statement and procname is the name supplied in the CREATE PROCEDURE statement.
- Declares a method within that class that includes the Java snippet. When an application calls the stored procedure, the SQL server calls the Java virtual machine to invoke the method of the username_procname_SP class.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |