Kbase P5976: Error 725 occurs when compiling stored procedure with 'send-sql-statement'
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Unknown or ambiguous table <table>. (725)
"Unknown or ambiguous table send-sql-statement. (725)"
Error occurs when trying to compile a stored procedure with send-sql-statement
RUN STORED-PROCEDURE send-sql-statement i_Handle = PROC-HANDLE NO-ERROR
("myfunction").
Compiling stored procedure when not connected to schema holder
CAUSE:
The SEND_SQL_STATEMENT is a hidden table within the schema holder.
FIX:
You must be connected to schema holder in order to compile a stored procedure.
This is an expected error message when not connected to the schema holder. The compiler correctly complains that the particular stored procedure "send-sql-statement" does not exist if not connected to the schema holder.