47: -- read html codes from that location
48: while amount > maxamount
49: loop
50: DBMS_LOB.READ(loc, maxamount, offset, output);
51: vLobPieces(vIndex) := utl_raw.cast_to_varchar2(output);
52: vIndex := vIndex + 1;
53: amount := amount - maxamount;
54: offset := offset + maxamount;
55: end loop;
55: end loop;
56:
57: if amount > 0 then
58: DBMS_LOB.READ(loc, amount, offset, output);
59: vLobPieces(vIndex) := utl_raw.cast_to_varchar2(output);
60: end if;
61:
62: return vLobPieces;
63:
363: * is different between client and server (e.g. UTF-8 to SJIS).
364: */
365:
366: /*
367: * utl_raw.convert only takes a qualified NLS_LANG value in
368: *
369: * source charset parameters. Need to use l_client_nls_lang
370: * and g_db_nls_lang here.
371: */
368: *
369: * source charset parameters. Need to use l_client_nls_lang
370: * and g_db_nls_lang here.
371: */
372: l_str := utl_raw.convert(utl_raw.cast_to_raw(l_onechar),
373: l_client_nls_lang,
374: g_db_nls_lang);
375: l_byte_len := length(l_str);
376: if l_byte_len = 2 then
443: i integer := 1;
444: begin
445: /*
446: * Set a source charset for code conversion.
447: * utl_raw.convert() only accepts
449: * 'AMERICAN_AMERICA' string if a give charset dose not have
450: *
451: */
480: /*
481: * convert a raw data from the source charset to the database charset,
482: * then cast it to a varchar2 string.
483: */
484: return utl_raw.cast_to_varchar2(
485: utl_raw.convert(l_raw, g_db_nls_lang, l_client_nls_lang));
486: end decode1;
487:
488: -- mdamle 11/08/2001
481: * convert a raw data from the source charset to the database charset,
482: * then cast it to a varchar2 string.
483: */
484: return utl_raw.cast_to_varchar2(
485: utl_raw.convert(l_raw, g_db_nls_lang, l_client_nls_lang));
486: end decode1;
487:
488: -- mdamle 11/08/2001
489: function getReportRegion(pFunctionName IN VARCHAR2) return varchar2 IS