www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
ap_add_phrases
ap_build_match_list
db.dba.ann_phrase_cl...
db.dba.ann_phrase_cl...
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

DB.DBA.ANN_PHRASE_CLASS_ADD

Returns APC_ID of a phrase class.
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 –
auth_pwd –
Examples
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.
See Also

DB.DBA.ANN_PHRASE_CLASS_DEL

AP_BUILD_MATCH_LIST