jcs.subscriber_info

PL/SQL API jcs.subscriber_info

Summary

• function subscriber_info(column_name in varchar2) return varchar2 (Only the values ''email_account'', ''id'', ''version'', ''description'', ''comment_text'', ''username'', ''lastmodification'', ''oracle_type'' and ''disabled'' for parameter column_name are supported)

Get user attributes such as address and email.

This is used by the subscription system to determine automatically certain values.

Exceptions

Specification

function subscriber_info(column_name in varchar2)
    return varchar2

Parameters

• column_name - name of a column in RS_USERS
• returns varchar2 - value of that column in RS_USERS for the current user

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

Examples

Using jcs.subscriber_info
       create or replace destination EMAIL_NOTIFICATION
       supports GENERIC using SYSJCS.EMAIL_NOTIFICATION
                            ( TO => JCS.SUBSCRIBER_INFO('EMAIL_ACCOUNT')
                            );

Using jcs.subscriber_info

See Also

• jcs_users (not implemented).