Kbase 18902: What data types in Oracle packages are supported by data server?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
What data types in Oracle packages are supported by data server?
GOAL:
Why cann't we mix Oracle 7 and Oracle 8 packages in the same schema holder?
GOAL:
What problems occur if you mix Oracle 7 and Oracle 8 packages?
FACT(s) (Environment):
Oracle DataServer
FIX:
ORACLE Packages are collections of pl/sql stored procedures and functions. These are supported by the Progress ORACLE DataServer since version 7.
Packages in Oracle can be seen when creating / pulling the schema from Oracle. It is important to load ORACLE 7 packages into a separate schema holder than ORACLE 8 packages. Both versions cannot be contained in the same schema holder.
If attempting to pull both ORACLE 8 and 7 packages, the following message will appear:
"Please also verify you have SELECT privileges on the needed system tables and the proper version of ORACLE (7 or 8) was selected when the schema holder was created (328) (6483)"
The Data Dictionary needs to read certain ORACLE system tables to determine which packages exist, the system tables that dataserver reads varies from Oracle version 7 to version 8. Progress must adjust the hidden files in the schema holder to reflect these changes. The -VO parameter is no longer used for this purpose. When using ORACLE database links, the linked database must be of the same version for the same reason.
The parameters to the stored procedures and functions the DataServer calls are restricted to ORACLE 7 data types. Progress does not support ORACLE 8 new objects (large objects, such as clobs and blobs), in the package. Thus, it is important to make sure you are not trying to use a package that contains these data types.