Message-Id: <10586.114408@fatcity.com> From: "Diego Cutrone" Date: Fri, 11 Aug 2000 17:10:55 -0300 Subject: RE: Problem with LONG_RAW column.. 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 Para: Multiple recipients of list ORACLE-L 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 Problem with LONG_RAW = column..
you can't do a SUBSTR to a LONG = field. Thats the=20 Illegal operation message.
Unfortunately I don't know what's the problem with = your PLSQL.=20 It seems fine to me
-----Mensaje = original-----
De:=20 Makarand Natu <Makarand.Natu@originindia.c= om>
Para:=20 Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
F= echa:=20 Viernes 11 de Agosto de 2000 4:30 PM
Asunto: Problem = with=20 LONG_RAW column..

Hi Gurus,

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
PL/SQL LONG RAW variable  it works well. =
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
  v_stuff LONG RAW; =
BEGIN
  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
this also reports ILLEGAL OPERATION.
I'm totally stuck on this.
Help=20 requested.

TIA,=20
Makarand=20