jeremy wrote:
>
> We already ran across something strange where use of
>
> substr(myvar,1,4000) resulted in a pl/sql numeric or value error as
> the number of chars returned (or do I mean bytes?) was actually 4001 -
> and we were trying to populate a pl/sql variable defined as
> varchar2(4000)... the developer then looked at substrb but I think
> that this is not the correct answer (though I could be wrong).
Realize that those symptoms will cascase through all of your
application! Suddenly, columns aren't wide enough, PL/SQL will
break, etc, etc.
BTDT - FvB
|
