While the following stored procedure works well if entered through SQL Studio, repmcli doesn't seem to like it:
Error during execution -->-25010 SQL error -5016 = Missing delimiter: ; (error position: 376) CREATE DBPROC debit (IN name VARCHAR(64), IN amount INT) AS VAR remaining INT; BEGIN SELECT credits INTO :remaining FROM expasy.users WHERE name = :name; IF remaining IS NOT NULL THEN BEGIN UPDATE expasy.users SET credits = credits - :amount WHERE name = :name; IF $rc = 300 THEN BEGIN STOP($rc, 'Not enough credits: ' || remaining); END; END; END; What am I doing wrong? -- Eric Jain _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
