Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CLOB to VARCHAR2
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.---