Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Stored Proc issues

Re: Oracle Stored Proc issues

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 6 Sep 2006 12:17:07 -0700
Message-ID: <1157570227.685545.184940@m79g2000cwm.googlegroups.com>


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

Original text of this message

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