Error when executing a stored procedure
Hello, We are developing some stored procedures at Version 11. In the code we call a FOR QUERY statement,
FOR field1,field2,field3,field4 IN QUERY SELECT field1,field2,field3,field4 FROM sometable LOOP RAISE NOTICE 'for returned %, %, %, %, FOUND=%',field1,field2,field3,field4, counter; counter:=counter+1; END LOOP;
The stored was created without problem, but when it's executed throw the next error:
SQL Error  [0A000]: [Vertica][VJDBC](10322) ERROR: Executing FOR (QUERY) is not yet supported
The documentation said this statement is supported, someone can we help us?