Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06502: PL/SQL: numeric or value error
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