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
?

.

Relevant Pages

  • Re: Error message on assignment line before rs.update
    ... TenderType as string ... as to what an Update statement would look like based on the Query. ...
    (microsoft.public.vb.database.ado)
  • Re: Forms and ODBC connections
    ... Thank you for your answer but it isn't clear to me the sintax you are using ... for the connection string and the update statement. ... > and the connection string mirrored that of my linked tables. ...
    (microsoft.public.access.formscoding)
  • Re: how to modify an xml field that may be plain text
    ... The update statement in a stored procedure and is actually designed to update any or all fields in the table. ... cases where the field is not an xml fragment but just a string. ... or it could just be this 'blah blah blah'. ... So when updating this field it might need to update just one of the nodes or the entire field (in the case where it's a simple string). ...
    (microsoft.public.sqlserver.xml)
  • Re: Edit records and UPDATE statements
    ... The connection string is in the web.config file and connects to the sql ... The SQL string is: ... my understanding is that cellas you see it in the UPDATE statement ...
    (microsoft.public.dotnet.general)
  • Re: Two columns have data mixed up need to fix
    ... How do you distingush whether a string value is a "Part Number" or a "name"? ... you can come up with an SQL predicate & use it in ... an UPDATE statement like: ...
    (microsoft.public.sqlserver.programming)