Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Triggers on $TA tables (Text Analysis Tables)

Hi Experts,

    Can we create triggers on Text Analysis Tables i.e. $TA tables (index tables) ??

Also, I have created an Information View (Projection Type on $TA table) and tried to use it in trigger with "INSTEAD OF" option.

But, it is not allowing to create trigger and giving below error :-

Trigger :-

CREATE TRIGGER TEST_TA

INSTEAD OF INSERT ON "TA_TEST"

FOR EACH ROW

BEGIN

    INSERT INTO SAMPLE VALUES(5);

END;

Error :-

Could not execute 'CREATE TRIGGER TEST_TA INSTEAD OF INSERT ON "TA_TEST" FOR EACH ROW BEGIN INSERT INTO SAMPLE ...'

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "INSTEAD": line 2 col 1 (at pos 26)

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question