Name

DB.DBA.ANN_PHRASE_CLASS_ADD — Returns APC_ID of a phrase class.

Synopsis

DB.DBA.ANN_PHRASE_CLASS_ADD ( in _name varchar ,
in _owner_uid integer ,
in _reader_gid integer ,
in _callback varchar ,
in _app_env any ,
in mode varchar ,
in auth_uname varchar ,
in auth_pwd varchar );

Description

The returned value is APC_ID of a class if positive or an error code if negative. To update phrase class, no special DB.DBA.ANN_PHRASE_CLASS_UPDATE() exists, use DB.DBA.ANN_PHRASE_CLASS_ADD() with parameter "mode" equal to 'replacing'.

Parameters

_name

a name of new phrase class

_owner_uid

owner UID, will be stored as APC_OWNER_UID, can be NULL for public

_reader_gid

reader GID, will be stored as APC_READER_GID, can be NULL for public

_callback

value for APC_CALLBACK field

_app_env

value for APC_APP_ENV field

mode

Instructs what to do on attempt of writing over existing class: 'into' will signal, 'soft' return APC_ID of (unchanged) existing class, 'replacing' will continue with update.

auth_uname

Authentication name

auth_pwd

Authentication password

Examples

Example24.292.ANN_PHRASE_CLASS_ADD

SQL>select ANN_PHRASE_CLASS_ADD ('My check', null, null, null, 'My check visa', '', 'dba', 'dba');
callret
INTEGER
_______________________________________________________________________________

1

1 Rows. -- 0 msec.

SQL>select ANN_PHRASE_CLASS_ADD ('Paid ads', null, null, null, 'Paid ads env', 'replacing', 'dba', 'dba');
callret
VARCHAR
_______________________________________________________________________________

2

1 Rows. -- 261 msec.