well, I answered you in another newsgroup, but since this might be of
interest to others, here's the answer:
you need a buffer LOB locator for this. Since the array element does not
yet exist when you call dbms_lob.createtemporary, you get this error (
createtemporary expects a valid assigned or unassigned LOB locator).
Declare a CLOB variable, pass it to dbms_lob.createtemporary and then
assign it to the array element.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Vasily Poushko" <vasily_at_genesyslab.ru> wrote in message news:abtt4t$4rr$1_at_octopus.co.ru...
> DECLARE
> TYPE CLOBL IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
> laMessages CLOBL;
> liPtr NUMBER;
> BEGIN
> laMessages.Delete;
> liPtr := 1;
> dbms_lob.createtemporary(laMessages( liPtr ), TRUE);
> END;
> /
>
> During running this code I get:
> ORA-01403: no data found
> ORA-06512: at line 8
>
> How can I initialize CLOB-array element without any errors?
>
> Regards,
> Vasily Poushko
>
>
Received on Wed May 15 2002 - 13:41:34 CDT
