Re: Oracle Stored Proc issues

Well, maybe I am not understanding your problem, but why don't you
declare the text variable to be some extra large number, something you
would never get near (like varchar2(4000) ). If you assign a short
string of text to the variable, then the variable will only contain
those characters (the string would not automatically be padded with
spaces to the max size).
The only thing you need to concern yourself with is where the text is
coming from and where it is going to. For example, if the text is
ultimatelly stored in a table column, then you must not allow it to be
longer then the column defined limit size. If the text is to be
displayed on the screen, then you might want to check the length/width
against your text box or window size.

Was there a reason for wanting to constrain the text to a smaller width
?
Received on Wed Sep 06 2006 - 14:17:07 CDT