Kbase P21332: Syntax error when running Stored Procedures from Crystal Rep
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/26/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Syntax error when running Stored Procedures from Crystal Reports 9.
Using a Stored Procedure without input/output parameters.
Syntax error (7587)
CAUSE:
The syntax for calling a Stored Procedure is:
- CALL sp_artic()
Instead Crystal Reports uses the following syntax:
- CALL sp_artic
This highlights that Crystal Reports is trying to call this Stored Procedure, but fails because of missing parenthesis at the end of the CALL statement.
FIX:
- Use an SQL command to specify the proper syntax to use when calling a Stored Procedure without parameters.
Or
- Create a Stored Procedure with a dummy input parameter.