DBA Data[Home] [Help]

APPS.BIS_PMV_UTIL dependencies on UTL_RAW

Line 51: vLobPieces(vIndex) := utl_raw.cast_to_varchar2(output);

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;

Line 59: vLobPieces(vIndex) := utl_raw.cast_to_varchar2(output);

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:

Line 367: * utl_raw.convert only takes a qualified NLS_LANG value in

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: * _. format for target and
369: * source charset parameters. Need to use l_client_nls_lang
370: * and g_db_nls_lang here.
371: */

Line 372: l_str := utl_raw.convert(utl_raw.cast_to_raw(l_onechar),

368: * _. format for target and
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

Line 447: * utl_raw.convert() only accepts _. format

443: i integer := 1;
444: begin
445: /*
446: * Set a source charset for code conversion.
447: * utl_raw.convert() only accepts _. format
448: * to specify source and destination charset and need to add a dummy
449: * 'AMERICAN_AMERICA' string if a give charset dose not have _
450: * information.
451: */

Line 484: return utl_raw.cast_to_varchar2(

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

Line 485: utl_raw.convert(l_raw, g_db_nls_lang, l_client_nls_lang));

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