AW: INSERT in DBPROC

David Radcliffe 
> 
> Hello,
> 
> I have an INSERT statement in a DBPROC which gives error -5004 (missing
> constant) when I try to place the name of a variable as a column value. If
> I
> place a literal character string in the insert statement, it compiles OK.
> 
> What am I doing wrong?
> 

did you define a variable, for example xyz and use it like this:
INSERT tabname VALUES (xyz)

The you forgot to prefix the variable_name (in SQL_statements only !) with :
INSERT tabname VALUES (:xyz)

Elke
SAP Labs Berlin


> 
> =======================================================
> This message is intended solely for the use of the individual or
> organisation to whom it is addressed.  It may contain privileged or
> confidential information.  If you have received this message in error,
> please notify the originator immediately.  If you are not the intended
> recipient, you should not use, copy, alter, or disclose the contents of
> this message.  All information or opinions expressed in this message
> and/or any attachments are those of the author and are not necessarily
> those of VarTecTelecom Europe Ltd or its affiliates. VarTec Telecom Europe
> Ltd accepts no responsibility for loss or damage arising from its use,
> including damage from virus.
> =======================================================


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx