Message-Id: <10586.114344@fatcity.com> From: Makarand Natu Date: Fri, 11 Aug 2000 17:27:38 +0530 Subject: Problem with LONG_RAW column.. 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 Problem with LONG_RAW column..

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