RE: Problem with LONG

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Fri, 11 Aug 2000 17:10:55 -0300
Message-Id: <10586.114408@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_03C9_01C003B7.1C74F7A0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

you can't do a SUBSTR to a LONG field. Thats the Illegal operation = message.
Unfortunately I don't know what's the problem with your PLSQL. It seems = fine to me

-----Mensaje original-----
 De: Makarand Natu <Makarand.Natu_at_originindia.com> Para: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Fecha: Viernes 11 de Agosto de 2000 4:30 PM Asunto: Problem with LONG_RAW column.. =20
 =20
 Hi Gurus,=20

I'm facing a problem with LONG RAW datatype.=20 When I'm trying to read a LONG RAW table column ( with size < 32K ) = in a=20

PL/SQL LONG RAW variable it works well.=20 However when the size of LONG RAW table column exceeds 32K it raises =

VALUE_ERROR exception. Foll. is my PL/SQL block...=20

    DECLARE=20
      v_stuff LONG RAW;=20
    BEGIN=20

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

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

TIA,=20
Makarand Natu=20

=20

------=_NextPart_000_03C9_01C003B7.1C74F7A0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type><TITLE>Problem with LONG_RAW = column..</TITLE><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<META content=3D'"MSHTML 4.72.2106.6"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>you can't do a SUBSTR to a LONG =
field. Thats the=20
Illegal operation message.</DIV>
<DIV>Unfortunately I don't know what's the problem with =
your PLSQL.=20
It seems fine to me</DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px">

<DIV>-----Mensaje = original----- De:=20

Makarand Natu <<A=20
=
href=3D"mailto:Makarand.Natu_at_originindia.com">Makarand.Natu_at_originindia.c= om</A>> Para:=20

Multiple recipients of list ORACLE-L <<A=20 =
href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>> F= echa:=20

Viernes 11 de Agosto de 2000 4:30 PM Asunto: Problem = with=20

    LONG_RAW column..<BR><BR></DIV></FONT>
    <P><FONT face=3DArial size=3D2>Hi Gurus,</FONT> </P>
    <P><FONT face=3DArial size=3D2>I'm facing a problem with LONG RAW=20

datatype. When I'm trying to = read a LONG=20

RAW table column ( with size < 32K ) in a <FONT = face=3DArial=20

size=3D2>PL/SQL LONG RAW variable  it works well. =
 <FONT=20

face=3DArial size=3D2>However when the size of LONG RAW table column = exceeds 32K=20

it raises VALUE_ERROR = exception. Foll. is=20

my PL/SQL block... 
DECLARE <FONT=20 face=3D"Courier New" size=3D2>  v_stuff LONG RAW; =
 <FONT=20

face=3D"Courier New" size=3D2>BEGIN <FONT face=3D"Courier = New"=20

size=3D2>  SELECT A.content  /* A.content is a column of = type LONG=20

RAW */   = INTO  =20

v_stuff   = FROM  =20

ows_content A   = WHERE=20
a.oid=3D24 ;   = ...Reports=20

VALUE_ERROR for size of A.content > 32K As a workaround for the above problem = when I try=20

the foll SELECT=20 UTL_RAW.SUBSTR(A.content,1,32000) INTO v_stuff <FONT = face=3DArial=20

size=3D2>this also reports ILLEGAL OPERATION. <FONT = face=3DArial=20

size=3D2>I'm totally stuck on this. Help=20

requested. 
TIA,=20

Makarand=20 Received on Fri Aug 11 2000 - 15:10:55 CDT

RE: Problem with LONG_RAW column..