How to call a procedure using Triggers?

[smanghnani23]

Hi,

I have created a simple procedure for the multiplication of 2 columns using table data type and the procedure is running smoothly but when i am calling that procedure with trigger it is not working and i am getting

1. Syntax Successfully Prepared.

2. not supported syntax in trigger: procedure (T4HMULTIPLY) :sql syntax error: incorrect syntax, single assign is not allowed

Code for the Trigger is :

Create TRIGGER Trigger1

After Insert OR DELETE OR UPDATE on EMPLOYEE

FOR EACH ROW

BEGIN

call multiply(?);

END;

[VolkerBarth]

So what database mangement system do you use: SQL Anywhere, SAP HANA, ...?

(Your tags are not clear in that respect.)

UPDATE: I turned that into an answer although it is none to prevent it from going unseen...