| prormsyn.sql synchronization script

Related topics
Use this script to remove the provider synchronization job from the SNP job queue. prormsyn.sql

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

Version: Oracle Portal 3.0.6.6.5 or later Deprecated: Oracle9iAS Portal 9.0.2
Prompted value:
subscriber_id | The ID of the subscriber that is running the job. If the value is left null, the default subscriber id is used. Note: The subscriber ID is the company ID when Oracle Portal is being used in hosted mode. If a Subscriber ID is not specified it defaults to 1 as this is the ID of the default company.
Example: To run the script: >SQLPLUS schema_name/password <Enter> >Run prormsyn <Enter> >Please enter the Subscriber ID for the job (value will default to default subscriber): ><Enter> If the submission is successful, these lines are displayed: >-- Job successfully removed from job queue. >-- Portal schema_name >-- Job#: job_number If an error occurs, these lines are displayed: >!!! ERROR: Failed to remove Portal synchronize job. >-- Portal: schema_name >!!! SQLERR: sql_error_message

Related topics
SNP provider synchronization scripts | PDK PL/SQL API Reference - Home

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