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 -> CLOB-array element initializing

CLOB-array element initializing

From: Vasily Poushko <vasily_at_genesyslab.ru>
Date: Wed, 15 May 2002 19:04:05 +0400
Message-ID: <abtt4t$4rr$1@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 - 10:04:05 CDT












Original text of this message













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