Kbase P125868: Error "procedure not found (7678)" occurs when calling a Stored Procedure
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/13/2007 |
|
Status: Unverified
SYMPTOM(s):
Error 7678 generated when calling a SQL-92 Stored Procedure
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20122
[JDBC Progress Driver]procedure not found (7678)
Schema name is used when calling the Stored Procedure:
CALL pub.someProcedure
Stored Procedure runs correctly when user is its creator/owner
SELECT * FROM sysprogress.sysprocedures shows that the creater and owner are the same
Permissions of the user have been restricted
User has EXECUTE rights on the Stored Procedure
Stored Procedure code calls a second Stored Procedure
Second Stored Procedure can be executed correctly independently of the first
CAUSE:
Code that calls the second Stored Procedure does not reference the schema name, therefore the procedure is not found
FIX:
Ensure that the name of the schema where the Stored Procedure is located is used when calling it