| Provider synchronization scripts

Related topics
| Deprecated in Oracle9iAS Portal 9.0.2 due to the introduction of provider groups.

Oracle Portal 3.0 uses SNP background processes that synchronize provider data at specified regular intervals. The scripts consolidate routines that would otherwise be handled by multiple Oracle Portal programs running for each user process. There are two of these scripts: projbmng.sql and prormsyn.sql. SNP background processes execute job queues. You can schedule routines to be performed periodically using the job queue. To schedule a job, you submit it to the job queue and specify the frequency at which the job is to be run. You can also alter or delete jobs you have submitted. Use projbmng.sql to submit the synchronization job to the job queue and to the change the job interval. Note: For more information about SNP background processes, see Oracle8i Reference, Release 2 (8.1.6), Part Number A76961-01.
Synchronization script name and description
projbmng.sql | Submits the Oracle Portal provider information synchronization job to the SNP job queue. Notes: If the job does not exist, run this script to submit the job. If the job already exists, run this script to change the interval in which this job is run.
prormsyn.sql | Removes the synchronization job from the SNP job queue.

| Only an Oracle Portal schema owner can submit a provider synchronization script.

Related topics
Provider API packages | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio