Skip to Content

How to call a procedure using Triggers?

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;

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 20, 2017 at 02:20 PM

    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...

    Add comment
    10|10000 characters needed characters exceeded