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 , 7 of 22


CAST_TO_VARCHAR2 Function

This function converts a RAW represented using n data bytes into VARCHAR2 with n data bytes.


Note:

When casting to a VARCHAR2, the current NLS character set is used for the characters within that VARCHAR2.  


Syntax

UTL_RAW.CAST_TO_VARCHAR2 (
   r IN RAW) 
  RETURN VARCHAR2;

Pragmas

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

Parameters

Table 80-4 CAST_TO_VARCHAR2 Function Parameters
Parameter  Description 
r
 

RAW (without leading length field) to be changed to a VARCHAR2). 

Returns

Table 80-5 CAST_TO_VARCHAR2 Function Returns
Return  Description 
VARCHAR2
 

Containing having the same data as the input RAW

NULL
 

If r input parameter was NULL


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