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: CLOB to VARCHAR2

Re: CLOB to VARCHAR2

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Fri, 26 Nov 99 10:47:17 GMT
Message-ID: <943613237.4951snx@aleytys.pc.my>


In article <fheq3s4uurbngpa26h1hc0eou1q2b36867_at_4ax.com> tkyte_at_us.oracle.com writes:

>don't ask me why but the author of the dbms_lob package made SUBSTR be:

>substr( lob, FOR_BYTES, FROM_OFFSET )

>instead of

>substr( log, from, for )

>as in SQL.....

Shouldn't this have been caught in quality control before dbms_lob was released into the wild? I trust a clue by four has been applied?

Philip

---=====================================================================---
 Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932    Guard us from the she-wolf and the wolf, and guard us from the thief,
                  oh Night, and so be good for us to pass.
---
 þ 10249.30 þ Where quality is just a word we like to use. Received on Fri Nov 26 1999 - 04:47:17 CST

Original text of this message

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