Kbase P125716: Error -219901 occurs when executing a SQL-92 Stored Procedure that inserts records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/7/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.0x
OpenEdge 10.1A
SYMPTOM(s):
Using SQL-92 Stored Procedure to insert records
Values are passed to the Stored Procedure as parameters
Error -219901 occurs when executing the Stored Procedure
SQLState=HY000
ErrorCode=-219901
[JDBC OpenEdge Driver]:Internal error -20152 (unknown sql92 error) in SQL from subsystem SQL92 function data_to_host called from stored_proc_t::execute on . for . Save log for Progress technical support.
No errors occur when Stored Procedure is created
CAUSE:
Bug# OE00096685
FIX:
Option #1
Upgrade to OpenEdge 10.1B or later
Option #2
Increase the format of the VARCHAR input parameters by one (1)