Re: Queues, RAWs and Objects.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/01/28
Message-ID: <949142777.3187.0.nnrp-13.9e984b29@news.demon.co.uk>#1/1

I think you need hextoraw() and rawtohex():-

declare

    n1 number(4);
    n2 number(4);
    r1 raw(24);
begin

    n1 := 23;
    r1 := hextoraw(n1);
    n2 := rawtohex(r1);

    dbms_output.put_line(n2);
end;

Objects is a charged option in 8.0
It might be included in 8.1, but I can't remember.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Paul Baker wrote in message <86mgqk$g74$1_at_soap.pipex.net>...


>I'm trying to create a simple queueing system that puts unique IDs in a

>queue. Unfortunately I can only seem to work with RAW data because the

>objects feature of my Oracle 8 enterprise edition is not enabled. Can

 anyone


>tell me how I enable this feature (I have a feeling that this will cost

>money)? Failing that, is there a way to convert RAW data into a 12-digit

>number and vice-versa?

>

>Thanks in advance for any help.

>

>Paul.

>

>

Received on Fri Jan 28 2000 - 00:00:00 CST