Skip to Content
0
Jun 05, 2020 at 08:20 AM

Cursor Error with Calculation View

113 Views

Hello,

i am trying to get a result set into a cursor from my calculation view to insert them then in another tables. It is all in stored prcedure.

I got the following error:

"search table error [34203]: Instantiation of calcjulation model failed; exception 306100: Text search is not supported"

My cursor definition:

DECLARE CURSOR <cursor name> FOR SELECT * FROM <calc view name> WHERE CONTAINS (EXTENDED_KEYWORD, <string i want to find in column>) AND NEWS_ITEM_TIMESTAMP > '2020-03-19 15:00:00.000000000' AND NEWS_ITEM_TIMESTAMP < '2020-03-19 20:05:00.000000000' ORDER BY TITLE;

Thank you for any help!