Re: Problem with LONG RAW datatype..

Problem with LONG RAW datatype..We've tried to fix the same problem and stopped calling the Oracle helpdesk after 14 days. They could not solve the problem either. This was about 1 year ago, using rdbms 7.3.4. My advise: look for other options. We saved large files on the filesystem and used utl file tho read them.

If you know an other solution, I'd love to know!

Good luck!

Eduard

  "Makarand Natu" <Makarand.Natu_at_originindia.com> schreef in bericht news:416EDB2D12C9D311B8AD00508B8BFA4B15D3B9_at_ORIGINWEB1...   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

--