Update procedure in Teiid Designer

[jane_lj]

Hi,

I'm writing update procedure in Teiid Designer 8.0, I gave this:

CREATE VIRTUAL PROCEDURE

BEGIN

INSERT INTO Petrel_SM.PetrelBorehole (UWI) VALUES (INPUTS.uwi);

END

But got this error:

ERROR: TEIID31119 Symbol INPUTS.uwi is specified with an unknown group context

I got this syntax from this doc http://docs.jboss.org/teiid/7.0.0/reference/en-US/html_single/#d0e4885, but not working with version 8.0.

1. How should I correct this procedure?

2. Where can I find update procedure docs for version 8.0?

Thanks a lot!

[rareddy]

Update procedures are removed in 8.0 if I am not mistaken.  Use "INSTEAD OF TRIGGER"

see https://docs.jboss.org/author/display/TEIID/Update+Procedures

Ramesh..

[jane_lj]

Ramesh,

This is very important information, othewise I will still be spending time on correct that syntax.

Will read that docs.

Thanks a lot.