Kbase P139727: Getting unsupported data type error when updating schema holder to pull stored procedure from Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/17/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting unsupported data type error when updating schema holder to pull stored procedure from Oracle
Error in the ds_upd.e file shown as:
ERROR: Table <stored procedure name> has unsupported data types.
Skipping this table...
FACT(s) (Environment):
The stored procedure is pulled into the schema holder even though the above error is displayed on the ds_upd.e file
The stored procedure contains %ROWTYPE output parameter
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
Oracle
Oracle DataServer
CAUSE:
The %ROWTYPE output parameter is not supported by OpenEdge Dataserver
FIX:
Use reference cursor output parameter instead