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

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