Oracle9iAS Portal Developer Kit

ptlrmsyn.sql synchronization script

Use this script to remove the portlet repository synchronization job from the SNP job queue.

ptlrmsyn.sql

Only an Oracle Portal schema owner can submit a portlet repository synchronization script.

Version: Oracle Portal 3.0.8

Prompted value:

subscriber_id

The ID of the subscriber that is running the job.

If the value is left null, the default subsriber ID is used.

Note:

  • The subscriber_id is only relevant when Oracle Portal is run in hosted mode.

Example:

To run the script:

>SQLPLUS schema_name/password <Enter>
>Run ptlrmsyn <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

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