Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06502: PL/SQL: numeric or value error

Re: ORA-06502: PL/SQL: numeric or value error

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 16 Aug 1999 12:09:07 GMT
Message-ID: <37bdff1e.4249360@newshost.us.oracle.com>


A copy of this was sent to Jürgen Potocnik <Juergen.Potocnik_at_t-online.de> (if that email address didn't require changing) On Mon, 16 Aug 1999 09:01:28 +0200, you wrote:

>hi,
>
>accessing internal blobs (size= 1mb up to 30mb) i got the message above.
>i use following pl/sql command:
>
>"dbms_lob.read(blob_src, amount, pos, buffer);"
>
>the buffer is
>"buffer raw (32767);"
>
>what must i do, to access the blob's correctly ?
>
>thanks in advance
>juergen potocnik

lets see the example code -- what are blob_src, amount and pos set to? they must be valid (eg: amount must be non null and some number less then/equal to 32k, pos must be valid and >= 1 <= max length of lob and so on...

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Aug 16 1999 - 07:09:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US