Kbase P130607: SQL-92: Unable to create a TABLE and a STORED PROCEDURE with the same name
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/04/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
SYMPTOM(s):
Using SQL-92 interface to connect to database
Creating a TABLE with the same name as a STORED PROCEDURE
Procedure already exists (7685)
SQLState=HY000
ErrorCode=-20140
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Procedure already exists (7685)
Creating a TABLE with the same name using the Data Dictionary succeeds without problems
CAUSE:
This is a known issue
FIX:
Workaround: Creating the table using the Data Dictionary will create the table in the "PUB" schema