This page describes the contents of the system services within IFS/Server. These services are used frequently in all generated procedures/functions. They can also be used in the user-defined methods.
The page also describes how to use dynamic pl/sql in programming and looks in detail into background jobs.
The system services are packaged in the following Oracle packages.
| Package | Description |
|---|---|
| Batch_SYS | Batch processes |
| Client_SYS | Client package routines |
| Command_SYS | Event Server/Connect 2.x activation |
| Connectivity_SYS | Inbox and Outbox manipulation |
| Error_SYS | Error handling |
| Event_SYS | Event registry services |
| General_SYS | General server tasks |
| Language_SYS | Language translation services |
| Message_SYS | Services concerning IFS Message |
| Object_Connection_SYS | Object connection services |
| Reference_SYS | Reference integrity services |
| Report_SYS | Report handling |
| Trace_SYS | Trace features for debugging |
| Transaction_SYS | Background jobs |
| User_Profile_SYS | Profile information |
| Utility_SYS | Miscellaneous services |
See the Foundation1 Reference Manual for detail information on the public interfaces in these system services.
Read about using dynamic pl/sql in Using Dynamic PL/SQL through DBMS_SQL.
Read about using dynamic pl/sql in Using Dynamic PL/SQL through DBMS_SQL.
Read about Using Conditional Compilation. In some situations it maight be more effective to use Conditional Compilation instead of Dynamic PL/SQL.
Read about background jobs in Programming with Background Jobs.