Overview
The OCL_CLIENT_PACK package consists of two files in the RXC_INSTALL directory, ocl_client_ps.sql
and ocl_client_pb.sql
. Refer to these files while reading this chapter. The files serve the following purposes:
ocl_client_ps.sql
- Package specification
- Creating the public synonym
- Granting execute privilege to both RXCLIN_MOD and RXCLIN_READ database roles
ocl_client_pb.sql
- Container for the function bodies for the OCL_CLIENT_PACK package
Use SQL*Plus from the RXC database account to execute ocl_client_ps.sql
:
- When initially installing the Oracle Clinical application
- Once after each time you modify the file
This file is a skeleton for creating custom validation and derivation because each function provides a stub; as delivered all validations succeeds and no derivation occurs. Each function includes detailed header comments that describe its purpose, parameters, and usage.
The functions in the OCL_CLIENT_PACK package are described in the following sections:
Functions for validation and derivation
Functions for page tracking
In each case, the function duplicates a function that already exists in the Oracle Clinical code. If you write new code for the function, your code supersedes the existing application code; otherwise, it simply uses the default system code. The SQL files ocl_client_ps.sql
and ocl_client_pb.sql
in the RXC_INSTALL are well commented, use them for additional information and to implement your custom functions.
Parent topic: Custom Identifier Handling