Package google_translate_pkg

Variables, constants

const g_lang_afrikaans

g_lang_afrikaans constant varchar2(5):='af'

http://code.google.com/apis/ajaxlanguage/documentation/reference.html#LangNameArray

const g_lang_albanian

g_lang_albanian constant varchar2(5):='sq'

const g_lang_amharic

g_lang_amharic constant varchar2(5):='am'

const g_lang_arabic

g_lang_arabic constant varchar2(5):='ar'

const g_lang_armenian

g_lang_armenian constant varchar2(5):='hy'

const g_lang_azerbaijani

g_lang_azerbaijani constant varchar2(5):='az'

const g_lang_basque

g_lang_basque constant varchar2(5):='eu'

const g_lang_belarusian

g_lang_belarusian constant varchar2(5):='be'

const g_lang_bengali

g_lang_bengali constant varchar2(5):='bn'

const g_lang_bihari

g_lang_bihari constant varchar2(5):='bh'

const g_lang_bulgarian

g_lang_bulgarian constant varchar2(5):='bg'

const g_lang_burmese

g_lang_burmese constant varchar2(5):='my'

const g_lang_catalan

g_lang_catalan constant varchar2(5):='ca'

const g_lang_cherokee

g_lang_cherokee constant varchar2(5):='chr'

const g_lang_chinese

g_lang_chinese constant varchar2(5):='zh'

const g_lang_chinese_simplified

g_lang_chinese_simplified constant varchar2(5):='zh-CN'

const g_lang_chinese_traditional

g_lang_chinese_traditional constant varchar2(5):='zh-TW'

const g_lang_croatian

g_lang_croatian constant varchar2(5):='hr'

const g_lang_czech

g_lang_czech constant varchar2(5):='cs'

const g_lang_danish

g_lang_danish constant varchar2(5):='da'

const g_lang_dhivehi

g_lang_dhivehi constant varchar2(5):='dv'

const g_lang_dutch

g_lang_dutch constant varchar2(5):='nl'

const g_lang_english

g_lang_english constant varchar2(5):='en'

const g_lang_esperanto

g_lang_esperanto constant varchar2(5):='eo'

const g_lang_estonian

g_lang_estonian constant varchar2(5):='et'

const g_lang_filipino

g_lang_filipino constant varchar2(5):='tl'

const g_lang_finnish

g_lang_finnish constant varchar2(5):='fi'

const g_lang_french

g_lang_french constant varchar2(5):='fr'

const g_lang_galician

g_lang_galician constant varchar2(5):='gl'

const g_lang_georgian

g_lang_georgian constant varchar2(5):='ka'

const g_lang_german

g_lang_german constant varchar2(5):='de'

const g_lang_greek

g_lang_greek constant varchar2(5):='el'

const g_lang_guarani

g_lang_guarani constant varchar2(5):='gn'

const g_lang_gujarati

g_lang_gujarati constant varchar2(5):='gu'

const g_lang_hebrew

g_lang_hebrew constant varchar2(5):='iw'

const g_lang_hindi

g_lang_hindi constant varchar2(5):='hi'

const g_lang_hungarian

g_lang_hungarian constant varchar2(5):='hu'

const g_lang_icelandic

g_lang_icelandic constant varchar2(5):='is'

const g_lang_indonesian

g_lang_indonesian constant varchar2(5):='id'

const g_lang_inuktitut

g_lang_inuktitut constant varchar2(5):='iu'

const g_lang_irish

g_lang_irish constant varchar2(5):='ga'

const g_lang_italian

g_lang_italian constant varchar2(5):='it'

const g_lang_japanese

g_lang_japanese constant varchar2(5):='ja'

const g_lang_kannada

g_lang_kannada constant varchar2(5):='kn'

const g_lang_kazakh

g_lang_kazakh constant varchar2(5):='kk'

const g_lang_khmer

g_lang_khmer constant varchar2(5):='km'

const g_lang_korean

g_lang_korean constant varchar2(5):='ko'

const g_lang_kurdish

g_lang_kurdish constant varchar2(5):='ku'

const g_lang_kyrgyz

g_lang_kyrgyz constant varchar2(5):='ky'

const g_lang_laothian

g_lang_laothian constant varchar2(5):='lo'

const g_lang_latvian

g_lang_latvian constant varchar2(5):='lv'

const g_lang_lithuanian

g_lang_lithuanian constant varchar2(5):='lt'

const g_lang_macedonian

g_lang_macedonian constant varchar2(5):='mk'

const g_lang_malay

g_lang_malay constant varchar2(5):='ms'

const g_lang_malayalam

g_lang_malayalam constant varchar2(5):='ml'

const g_lang_maltese

g_lang_maltese constant varchar2(5):='mt'

const g_lang_marathi

g_lang_marathi constant varchar2(5):='mr'

const g_lang_mongolian

g_lang_mongolian constant varchar2(5):='mn'

const g_lang_nepali

g_lang_nepali constant varchar2(5):='ne'

const g_lang_norwegian

g_lang_norwegian constant varchar2(5):='no'

const g_lang_oriya

g_lang_oriya constant varchar2(5):='or'

const g_lang_pashto

g_lang_pashto constant varchar2(5):='ps'

const g_lang_persian

g_lang_persian constant varchar2(5):='fa'

const g_lang_polish

g_lang_polish constant varchar2(5):='pl'

const g_lang_portuguese

g_lang_portuguese constant varchar2(5):='pt-PT'

const g_lang_punjabi

g_lang_punjabi constant varchar2(5):='pa'

const g_lang_romanian

g_lang_romanian constant varchar2(5):='ro'

const g_lang_russian

g_lang_russian constant varchar2(5):='ru'

const g_lang_sanskrit

g_lang_sanskrit constant varchar2(5):='sa'

const g_lang_serbian

g_lang_serbian constant varchar2(5):='sr'

const g_lang_sindhi

g_lang_sindhi constant varchar2(5):='sd'

const g_lang_sinhalese

g_lang_sinhalese constant varchar2(5):='si'

const g_lang_slovak

g_lang_slovak constant varchar2(5):='sk'

const g_lang_slovenian

g_lang_slovenian constant varchar2(5):='sl'

const g_lang_spanish

g_lang_spanish constant varchar2(5):='es'

const g_lang_swahili

g_lang_swahili constant varchar2(5):='sw'

const g_lang_swedish

g_lang_swedish constant varchar2(5):='sv'

const g_lang_tajik

g_lang_tajik constant varchar2(5):='tg'

const g_lang_tamil

g_lang_tamil constant varchar2(5):='ta'

const g_lang_tagalog

g_lang_tagalog constant varchar2(5):='tl'

const g_lang_telugu

g_lang_telugu constant varchar2(5):='te'

const g_lang_thai

g_lang_thai constant varchar2(5):='th'

const g_lang_tibetan

g_lang_tibetan constant varchar2(5):='bo'

const g_lang_turkish

g_lang_turkish constant varchar2(5):='tr'

const g_lang_ukrainian

g_lang_ukrainian constant varchar2(5):='uk'

const g_lang_urdu

g_lang_urdu constant varchar2(5):='ur'

const g_lang_uzbek

g_lang_uzbek constant varchar2(5):='uz'

const g_lang_uighur

g_lang_uighur constant varchar2(5):='ug'

const g_lang_vietnamese

g_lang_vietnamese constant varchar2(5):='vi'

const g_lang_welsh

g_lang_welsh constant varchar2(5):='cy'

const g_lang_yiddish

g_lang_yiddish constant varchar2(5):='yi'

const g_lang_unknown

g_lang_unknown constant varchar2(5):=''

Functions, procedures

function translate_text

function translate_text(
    p_text in varchar2,
    p_to_lang in varchar2,
    p_from_lang in varchar2:=null,
    p_use_cache in varchar2:=YES
) return varchar2

translate a piece of text

function detect_lang

function detect_lang(
    p_text in varchar2
) return varchar2

detect language code for text

function get_translation_cache_count

function get_translation_cache_count return number

get number of texts in cache

procedure clear_translation_cache

procedure clear_translation_cache

clear translation cache