Re: Oracle Stored Proc issues

That sounds good. I use the value in the update statement.

something like
update ... where xyz in ( variable )

Thanks

G Quesnel wrote:
> 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:24:22 CDT