Kbase P66180: Attempting to run java stored procedure from SQL92 client and getting error. Error reads Error in S
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/11/2009 |
|
Status: Verified
SYMPTOM(s):
Error in Stored Procedure Execution. (7853)
Attempting to run java stored procedure from SQL92 client and getting error. Error reads Error in Stored Procedure Execution. (7853)
FACT(s) (Environment):
UNIX
Progress 9.x
OpenEdge 10.x
OpenEdge Category: SQL
CAUSE:
To utilize Java Stored Procedures some environment variables and some addition PATH and CLASSPATH infromation is necessary.
The database server needs to have these set before it is started so SQL clients which connect will have them available.
This error indicates that the necessary variables have not been set.
FIX:
Make sure that the sql_env script is run or called from your script prior to starting the Progress database(s).
Typically the following syntax is used to run the script and cast the variables in the script into the calling environment:
. $DLC/bin/sql_env