Skip to Content
0

How to call a procedure using Triggers?

Sep 18, 2017 at 12:38 PM

153

avatar image
Former Member

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;

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Volker Barth Sep 20, 2017 at 02:20 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded