Jenny Zhang wrote: >The following is the dbproc code which caused this problem (-9405): >SELECT i_stock INTO :i_stock FROM dbt.item WHERE i_id=:scl_i_id; >IF (i_stock-10>scl_qty) >THEN > UPDATE dbt.item set i_stock=(:i_stock-:scl_qty) where i_id=:scl_i_id >ELSE > UPDATE dbt.item set i_stock=(:i_stock-:scl_qty+21) where i_id=:scl_i_id;
The reason for that problem is the expression :i_stock-:scl_qty in the update statement. The parser unfortunately allows the minus '-' in parameter names, i.e. :i_stock- is interpreted as parameter name and :scl_qty is interpreted as indicator variable. You have to separate the '-' by blanks, until the error has been corrected (i.e. :i_stock - :scl_qty). Thanks again for reporting the bug. Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
