Kbase P86497: Can't compile SQL92 stored procedure when userid contains space(s)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/09/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
An error is returned when trying to compile a STORED PROCEDURE in SQL-92.
[JDBC Progress Driver]:error in compiling the stored procedure
The UserID of the user who compiles the STORED PROCEDURE contains a space
E.g. UerID = aa bb
CAUSE:
When compiling SQL-92 stored procedure, a Java file is generated.
The generated files is by default named the UserID of the user compiling the procedure, plus the procedure name.
If the userid contains space(s), the fails to compile.
FIX:
Prefix the stored procedure name with a schema name.
Example:
CREATE PROCEDURE <schema_name>.<procedure_name>:
BEGIN
<code>
END;