Kbase P124855: SQL-92: Can a Stored Procedure be invoked from an ODBC client?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/11/2007 |
|
Status: Unverified
GOAL:
What is an SQL-92 Stored Procedure?
GOAL:
SQL-92: Can a Stored Procedure be invoked from an ODBC client?
GOAL:
SQL-92: Can a Stored Procedure be called when the database is connected using the ODBC driver?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
A stored procedure is a snippet of JAVA code embedded in an CREATE PROCEDURE statement. The Java snippet can use all standard Java features as well as use OpenEdge SQL-supplied Java classes for processing any number of SQL statements.
Once a stored procedure is created and stored in the database, any application or other stored procedure can execute it regardless whether the underlying connection to the database was established using a JDBC or an ODBC driver. In other words, stored procedures may be invoked from either an ODBC client application or a JDBC client application.