Re: concatenate RAW data in PL/SQL with R7.3.2

From: Venkateswara R Polisetti <vrao_at_sctcorp.com>
Date: 1996/08/30
Message-ID: <1996Aug30.133600.8502_at_mcrcr6>#1/1

mtsao_at_cas.org wrote:

>In PL/SQL there are concatenation operator and function for VARCHAR2
>datatype and its subtype -- "||", concat() -- to put string together
>such as:
 

> DECLARE
> string1 VARCHAR(10) := 'one';
> string2 VARCHAR(10) := ' piece';
> string3 VARCHAR(20);
> BEGIN
> string3 := string1 || string2;
> END

>but there is no such such built-in function for RAW datatype.
 

>Is there any techniques available in PL/SQL to concatenate RAW datatype ?
 

>Thanks in advance, Ming Tsao
>--

There is a package called utl_raw in utl_raw.sql in $ORACLE_HOME/rdbms/admin directory. This file contains only the package specification. This package include functions like concat, substr, lenth etc which work with RAW data type. But I failed to locate the package body in the sql files located in this directory. There is another file catrep.sql, in which this utl_raw script is referenced. I think this script is meant for Oracle systems with Replication option installed. If you have replacation installed on your system then you may want to check these files once.

Venkateswara Rao.
/-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-\

| Venkateswara R.Polisetti                 Email: vrao_at_sctcorp.com  |
| SCT Utility Systems, Inc.             Phone(O): (803) 935-8160    |
| 9 Science Court                            (R): (803) 736-1609    |
| Columbia, SC  29203-9344                                          |

\-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-/ Received on Fri Aug 30 1996 - 00:00:00 CEST