Kbase 21945: Table/View/Synonym already exists (7535) -- Stored Procedure
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/19/2002 |
|
SUMMARY:
This Solution documents one reason for error 7535, which you might see when compiling a Java Stored Procedure:
Table/View/Synonym already exists (7535)
EXPLANATION:
This error is caused due to the fact that both database tables and procedures are sharing the same system table -- systabauth. The name of your Stored Procedure should not have the same name as any other Stored Procedure or table in the database.
This does not apply to triggers since they do not share the systabauth system table.
However, if you first create your Stored Procedure and afterwards create a table with an identical name, you will not receive this error but you will instead end up with a table and a procedure with identical names.
This issue has been reported to Progress Development with the reference number 20011022-004. It is fixed in Progress Version 9.1D. The fix prevents creating a table and a procedure with identical names.