RE: VARCHAR LENGTH

jain cj wrote:

> 
> Hi,
> 
>    I want ot add a big query into a Varchar String . I defined it 
> Varchar(8000) . but it not supporting to store 8000 
> characters. It throws 
> error like
> 
> ---- Error -------------------------------
> Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> General error;-2010 POS(1) Assignment impossible, char value too long.
> call SI_SF_FINDDEPACCTBYCUST(1)
> 
> How can i solve the problem. Please please help me...I really 
> stuck with the 
> problem

Please tell us
- if you are using SQLMODE Oracle or internal
- how the full tabledefinition looks like
- how does the statement look like
- if there are triggers defined on top of this table 
- if this statement is a procedure-call, how does the
  the dbproc look like. and which of its statements inside
  causes the error to occur

Elke
SAP Labs Berlin