Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

UTL_RAW , 18 of 22


CONVERT Function

This function converts RAW r from character set from_charset to character set to_charset and returns the resulting RAW.

Both from_charset and to_charset must be supported character sets defined to the Oracle server.

Syntax

UTL_RAW.CONVERT (
   r            IN RAW,
   to_charset   IN VARCHAR2,
   from_charset IN VARCHAR2) 
  RETURN RAW;

Pragmas

pragma restrict_references(convert, WNDS, RNDS, WNPS, RNPS);  

Parameters

Table 80-33 CONVERT Function Parameters
Parameter  Description 
r
 

RAW byte-string to be converted. 

to_charset
 

Name of NLS character set to which r is converted. 

from_charset
 

Name of NLS character set in which r is supplied. 

Returns

Table 80-34 CONVERT Function Returns
Return  Description 
RAW
 

Byte string r converted according to the specified character sets. 

Errors

Table 80-35 CONVERT Function Errors
Error  Description 
VALUE_ERROR
 

Either:

- r missing, NULL, and/or 0 length

- from_charset or to_charset missing, NULL, and/or 0 length

- from_charset or to_charset names invalid or unsupported 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback