Problem with LONG_RAW column..

From: Makarand Natu <Makarand.Natu_at_originindia.com>
Date: Fri, 11 Aug 2000 17:27:38 +0530
Message-Id: <10586.114344@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0038B.5B4E5E70
Content-Type: text/plain

Hi Gurus,

I'm facing a problem with LONG RAW datatype. When I'm trying to read a LONG RAW table column ( with size < 32K ) in a PL/SQL LONG RAW variable it works well. However when the size of LONG RAW table column exceeds 32K it raises VALUE_ERROR exception. Foll. is my PL/SQL block...

DECLARE
  v_stuff LONG RAW;
BEGIN
  SELECT A.content /* A.content is a column of type LONG RAW */   INTO v_stuff
  FROM ows_content A
  WHERE a.oid=24 ;
  ...Reports VALUE_ERROR for size of A.content > 32K

As a workaround for the above problem when I try the foll SELECT UTL_RAW.SUBSTR(A.content,1,32000) INTO v_stuff this also reports ILLEGAL OPERATION.
I'm totally stuck on this.
Help requested.

TIA,
Makarand Natu

------_=_NextPart_001_01C0038B.5B4E5E70
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>Problem with LONG_RAW column..</TITLE>
</HEAD>
<BODY>

Hi Gurus,


I'm facing a problem with LONG RAW datatype.
 When I'm trying to read a LONG RAW table column ( with size < 32K ) in a 
 PL/SQL LONG RAW variable  it works well.
 However when the size of LONG RAW table column exceeds 32K it raises
 VALUE_ERROR exception. Foll. is my PL/SQL block...


DECLARE
   v_stuff LONG RAW; 
 BEGIN
   SELECT A.content  /* A.content is a column of type LONG RAW */
   INTO   v_stuff
   FROM   ows_content A
   WHERE a.oid=24 ;
   ...Reports VALUE_ERROR for size of A.content > 32K


As a workaround for the above problem when I try the foll
 SELECT UTL_RAW.SUBSTR(A.content,1,32000) INTO v_stuff
 this also reports ILLEGAL OPERATION.
 I'm totally stuck on this. 
 Help requested.


TIA,
 Makarand Natu
Received on Fri Aug 11 2000 - 06:57:38 CDT